You can see this model in the Northwinds database which comes with Access. Basically you will want three tables. One table will be for your customer information where CustomerID is your primary key (PK).
The second table will be like an inventory table listing your products, price, item number (PK), and on hand quantity. The third table is what is called a join table. This table will be your Orders table and will join the information from your Customer table (CustomerID) and from your Products table (ItemNumber). You will also want other fields in your join table such as quantity, order date, ship date, various costs such as shipping and handling, total cost. The reason you want a separate order table is because you may have a customer that orders more than one time. When the order is placed you can subtract the quantity ordered from the quantity on hand. You could set an OrderWhenQuanity value for each item in your inventory table and then when the quantity on hand is equal to or less than that OrderWhenQuanity value you will know to order more of that product. I hope this helps. Glenn P. Jones -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of peaches1979_2001 Sent: Thursday, 22 December, 2005 01:00 To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Need Help with my Access File Can any one help me with my access file? I could not able to upload to the group in the files folder. I have these two tables: Customer: ID, Name, Address, City, State, Zip, Email Sold: Auto Number, Item Number, Discription, Qty, Price How do I link them to the Customer ID just using that? I want each record different for the customer so that I could have a copy of it. I setup my query using the auto number, but it tells me it is invaild expression. IF anyone could help me with it, I appreciate it. Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income homes are not online. Make a difference this holiday season! http://us.click.yahoo.com/5UeCyC/BWHMAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
