Adding Records

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding Records 1
Adding a Record 1
Adding many records at 1 time 1
Copy previous record into form field 0
how to create new record automatically 2
Create report that subtracts data over two years 4
no matching record on the "one" side in one-to-many relationship 1
Relationship for Market at Customer-Product Level 4

Top