Adding a Record

[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

 

[Bill Crawford]

HI:

If you have a form for data entry into the table you can use the command
button wizard to create a button to enter a duplicate record of the current
record in focus.