(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?