error when two identical items from the same table are included

G

Guest

In "Northwind Traders Database" the "Orders subForm" has a combobox for user
to select Products. No product can be selected more than once on the same
order. How can we change this so the same product can be selected as many
times as the user wishes?
 
G

Guest

That would be major surgery. The ProductID is part of the table's primary
key. To change that would mean changing all the relationships involved.
 
J

Joan Wild

In addition, I would think that the qty field would be used to order more
than one of any product.
 
R

Rick Brandt

We have some customers who insist that like products (in some cases) be on
separate lines. It makes more sense in a system where an ordered item contains
sub-items where the sub-item configuration might be different. All it takes is
a surrogate key that is not tied to the real data. Certainly not a foreign
concept in these groups.
 

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

Add new product on Orders form (Northwind) 1
combobox population record dependent 4
Quad Cascading ComboBoxes 3
Order Entry 3
Random lists PRINT identical items daily 7
adding records to a sub form 2
Rollback changes made to "1 to Many" records being edited in a mainform / subform combination. 1
Scrolling through data on a subform while the labels are stationar 2

Top