filter values ?

[santosh]

in employee table having field designation and values are in this field as admin,head,technician,lab assistance,etc. and want to filter values in other layout as two fields one is designation and other is emp name and as we select the lab assistance designation only lab assistant employees list show in drop down in emp name field.

how can i do this?

explain with example file..

[LaRetta]

It sounds like you need a conditional value list. Go to Comment's blog and scroll down until you come to several samples on setting them up. :smile2: