benbacardi

in microsoft access, you can have a combo box with values from another table in it, for example, a foreign key to link the two tables together. How can i gather this data and put it into a selection box using asp for the web-based interface?

thanks

ben

Smokie

Try creating a query in access which gets all the data you want, then save the query.

Then in your ASP code, put "SELECT * FROM yourQueryName", then simply loop through the records as normal.

I presume that when you say "selection box" you mean a multiselect list box?

benbacardi

no, i mean like a combo box in access, a <select><option>....</option></select> thingy