I have a repeating region that contains a dynamic drop down
menu but my drop down menu is displaying all results instead of
just the ones associated with that item. I have two tables in my DB
(ACCESS)(ASP), Items and Prices which are related by their Item ID
numbers. There are multiple quantities and prices for each item. I
want the drop down menu to show only the quantities available to
I currently have two recordsets, RecordsetItems and
RecordsetPrices. Do the two need to be combined to display properly
in my drop down menu? I've tried combining them but I then get
multiple listings for each item.
If anyone would point me in the right direction I would
really appreciate it.