I am currently working on a database and would like to link search criteria fields to one another. For example, I have a drop down list that shows the year a certain event took place. Ideally, once a user selects say, "2001", I would like all the events that occurred during 2001 to be displayed. Unfortunately, at the moment, a user will have to scroll over to the next field and use the drop down list which contains all the events that took place from 2000 to 2006. Is there anyone out there who knows how to create the relationships I am trying to establish? Basically create a system whereby a user can select 2001 and automatically have ONLY the title of events that took place in 2001 show up in the next search field? Any help would be greatly appreciated. I have attached a zip file of the database page that I am working on. Please log on as "Guest".

If you scroll down to "Workshop" and double click on "Year", you will see the drop down. Next to this search field is "Title", which is also a drop down list. I am trying to link the two so that only the appropriate workshops titles that took place in the pre-selected year are displayed for selection. Again, any help would be appreciated. Thanks,

Nemesis

help.zip

Seems to me like you are looking for a conditional value list. Perform a search for +conditional +value +list and you will see lots of posts on it.

Good luck.