0 Replies Latest reply on Jul 19, 2007 3:39 PM by imjusthere2

    combining recordsets? NEED HELP

      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 that item.

      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.

      Thank you for your help,