Adding Records

[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

 

[Jeff Boyce]

Stephen

Already answered under another post by you -- why post twice?

Jeff Boyce
<Access MVP>