Subform unique ID

  • Thread starter Thread starter SF
  • Start date Start date
S

SF

Hi,

I have sale form consist of a subform that list drinks of a particular
table. The subform was designed to hold a unique product id. Most of the
time the order for drinks can take up to 20 items and the saler is having
difficulty in browsing the subform up and down looking for the items whether
it has been entered once. Is there a way to allow the product to be entered
more than once and than, access will group the product and quantity order?

SF
 
It just depends on how you've designed your tables. As long as you don't
have a unique index built on the Orderid and DrinkID fields you should be
able to do it. Often in OrderDetail tables the unique index for the table is
a combination of the Orderid and a LineNumber.
 
Back
Top