Database Results - Query - Access

[weberbill]

http://www.precisionsupply.com/search.asp

is the page in question.

I have to drop down boxes (level1drop and level2drop) that will make a selection. These are pulled from a LEVEL table.

level1drop - allows selection of letters
level2drop - allows selection of numbers

I want to have the user select a letter (level1drop) and select a number (level2drop) and then click submit and have results returned from a NAME table. The NAME table will then return Firstname, Lastname, Level1, Level2 and Level3. I inserted paraments in the query for level1drop and levell2drop, but it didn't work. The query is below.

SELECT * FROM name where ::level1drop::=level1 and ::level2drop::=level2

level1 - in the NAME table
level2 - in the NAME table

The database is downloadable too...

http://www.precisionsupply.com/db1.mdb

Thank you in advance for you help!
Bill Weber
bweber@precisionsupply.com

 

[DeZiner]

The main thing I see is that your <options> have no values

<option value=&quot;a&quot;>a</option>

Secondly your syntax is backwards:
level1drop::=level1 and ::level2drop::=level2

This says where the dropdown is = tp the table. You need to say where the table is = to the dropdown. I haven't personally seen sql with :: in it. Not sure if that is valid either. DeZiner
Never be afraid to try something new.
Remember that amateurs built the Ark.
Professionals built the Titanic