I'd like to search by key words from many columns in one table by using list/menu but I don't know how to set the value of list/menu. You will understand what I try to say in the picture.

See the picture of trouble I have.www.geocities.com/khanittha_nita/search.html?1031873539384

Products On Sales : Searching from column OnSales(Datatype = Yes/No)
Online-Products : Searching from column ActiveProduct (Datatype = Yes/No)
Offline-Products : Searching from column ActiveProduct (Datatype = Yes/No)
They all are in table "Products".

Anyone PLEASE help me out. By the way, My English is not good so Sorry If I make you confuse.

To set values for your list menu, select the list menu on your page and in the properties panel select the button that says list values, here you can set the list menu labels and the values that match to that label, then use the list menu to search your table

hope this helps

Iain

head hurts, 'mental note to self, stop banging head !'

The problem is I don't know what the code should be like. Would you please give me an example.

I was having a similar headache.

Follow this link and it might help in solving your problem.

www.udzone.com/forum/topic.aspTOPIC_ID=19201&FORUM_ID=3&CAT_ID=2&Topic_Title=Search+multible+tables&Forum_Title=Dreamweaver+UltraDev

(you may have to paste it into your address bar as I dont think the whole link works like this)

Cheers

Red Leader

Sorry! last link didn't appear to work.

This one should

www.udzone.com/forum/topic.asp?TOPIC_ID=19201&FORUM_ID=3&CAT_ID=2&Topic_Title=Search+multible+tables&Forum_Title=Dreamweaver+UltraDev

Red Leader