0 Replies Latest reply on Jul 18, 2007 10:30 AM by imjusthere2

    dynamic drop down menu in a looper

    imjusthere2 Level 1
      (I'm using an Access DB in ASP)
      I have a looper and in it I've placed a dynamic drop down menu. I have two tables in my DB (items and prices which are related via the item's ID Number). What happens when I run it is I get every value in every drop down instead of what I want which is only the values associated with that product. Right now I have it set up as two different recordsets (Recordset1 and RecordsetPrice). Does this need to be somehow integrated into one recordset, and how do I do this?

      Thank you,
      Chris