|
-
Apr 29th, 2013, 11:22 AM
#5
Thread Starter
Addicted Member
Re: Quick Question - how would you do this?
Unfortunately i'm still having trouble getting this to work 
The pic below shows the 2 tables (Products & SerialNumbers)
I thought it was best if the serial numbers were put in their own table - so 1 product could have 500 serial numbers, and the tables are linked by the ProductID (Primary keys are set to autonumber in both tables)
I've tried to do a simple query but it wont work, any ideas what i'm doing wrong?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote