Adding Records

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

I have a database with Tables
"Customer" & "CustomProducts".

"CustomProducts" contains fields like:
CustomerID, ProductID, SellPrice, Active/Inactive, Active
Date...

The two tables are linked through a field
named "CustomerID".

I want to add 1 identical record within "CustomProducts"
for every "Customer".

I hope this is enough info. Any help would be
appreciated. Thanks in advance.

Stephen.
 
It is not really clear to me what and why you want to do.

I can make a couple of suggestions.

If you will have exactly the same number of records in each table and
each record in each table is linked to only one record in the other table,
why do you want two tables?

If, as I suspect you will have one record for each customer in that
table and you will add a customer only when they make their first purchase
and therefore will have a record in the purchase table, and maybe additional
records in the purchase table for the same customer, you have the right
design to start with.

You do not need to "add" a record to the purchase table, it will
automatically added when you add the purchase.

Look up the information on forms and subforms. That should answer your
question about how to handle the question. The customer would be the form
and the purchases would be the subform.
 
Back
Top