Hi, You need three tables. 1) Customer info
2) Items info (Part ID, Description and part number) the part number might be the part id. 3) Purchases. (Customer ID, Item ID, Number purchased) You might set up a customer form with a subform to pick the items and add the number sold. Good luck Keith ----- Original Message ----- From: "sconi250" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, August 09, 2006 3:51 AM Subject: [ms_access] Setting up a simple database form I am kind of new to databases. I am trying to create a simple form for to enter customer information. I want the form to display the customer name and address, and then I also want to be able to put in the specfic parts they have bought from us in the past, want there part number is and how many they used. Right now have have two tables. The customer table with the name and address and the product table with part numbers there part numbers and how many they used. I created a form with a product table as a subform. This dosn't seem to be working because if 2 customers use the same part number it will change the usage and customer number. I need a form that will let me enter customer contact information in and part number usage for each customer specificlly without updating the product each time, because every customer uses different amounts of the part and has different customer numbers. Any information will help greatly. Thanks Yahoo! Groups Links __________ NOD32 1.1701 (20060810) Information __________ This message was checked by NOD32 antivirus system. http://www.nod32.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> 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/
