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
<*> 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/
