Adding many records at 1 time



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

"Customers" contain all Customer Info, i.e. CustomerID,
CustomerName, Address, Phone, Etc.

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

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

I enter orders into Tables
called "Orders", "OrderDetails" for a Customer by
selecting that Customers Specific Products for
the "CustomProducts" Table.

I want to add 1 identical record within "CustomProducts"
for every "Customer", so I can sell the same product to
many customers.

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


Jeff Boyce


If you are considering "adding 1 identical record" in another table, it's
probably time to step back from the computer and revisit your
normalization/design. One of the advantages of a relational database
(Access) is that you don't need to duplicate records.

Instead of "how" you're trying to do something, could you describe what
business need you are trying to satisfy?

Good luck

Jeff Boyce
<Access MVP>

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 Records 1
Adding a Record 1
database design for inventory 1
bakery database 1
Order Entry type form to add to three tables 11
How to left 5
Normalization? 12