Hi
I am trying to setup a Dynamic List menu in search page. I have no idea how to set it up so that it can bring data from database.

Note: My DB Holds: 4 Culums which I want to make searchable (e.g. Type, Region, Bedroom, Price_range)

I did try like this, I created a List menu first.
Then Name it s_type.
Pressing Dynamic button - then
menu section "type_s" in form "sales_search"
Static option -
Value = -1 , Label = No Preferances
Options from recordset = rsSales_search
Values = type
Labels = type
Select Value equal to =
<%= (rsSales_search.Fields.Item("Type".Value) %>

When I run the page then it show me all the records from that TYPE CULUM,
It should show me eg:-
Duplex
Apartment
Flat

Instead it is showing me -
Duplex
Apartment
Flat
Duplex
Apartment
Flat
Duplex
Apartment
Flat
I mean all the records.

I never done these before. Please any friend help me with these. How to configure Dynamic List/Menu.
Or Advice me where can I get a basic tutorial about this.

Thanks

Babu

Edited by - babui on 05 Oct 2004 16:46:44