script for find when user give input on edit box

[Alpana]

hi

i have a dropdownlist in which number of table field are present .when user select any one field from dropdown and fill any value in edit box then how i find record ? ex---- in dropdownlist status,createdby etc field are present .when user select status and fill any value in editbox like Delay.if user select created by from dropdown and in edit box fill A then how i write script for searching(FIND)

Thanks

[Inky Phil]

Create global fields for the user to enter the data.

 

Create a 'find' button and attach a script to it that first of all enters find mode then sets the search fields to the value of the global fields and then performs the find

 

hth

Phil

[Alpana]

hi

but how i know which field is selected by user(in dropdown)

can u write script

thanks

[Inky Phil]

I am sorry I do not understand your question. In order to help you further it would be a lot easier if you can upload a sample of your file and i can the perhaps write the script for you

 

Phil

[Alpana]

sorry i cant't post my file because i m not cafe member

 

i have 3 column in database

1 department

2 status

3 created by

 

my searching criteria is

"department=department1 where status="delay"

 

user can select status or created by and according to selection my query is change

 

"department=department1 where created by="A"

or

"department=department1 where status="delay"

 

now i hope u understand my condition

plz help me