Getting info from two unrelated DB tables

[iisman]

I currently have a page that gets data from one table, and displays th34e info for each item, and loops.

strSQL = "Select * From tblproj WHERE projcategory LIKE " & strShowCat & " AND projstatus Not LIKE 4"

I want to get data from a separate table, to populate a dropdown selection that needs to be displayed for each item.

does anyone know how i can do this?

thanks in advnace for the help

 

[tsdragon]

Use a totally separate query to build one dropdown first. Then clone it for each record as you display it.


Tracy Dryden

Meddle not in the affairs of dragons,
For you are crunchy, and good with mustard.