I've looked at lots of other threads and faq and am still not sure of how to do this. I need to implement a simple search system.
The user must choose their criteria by which to search either ID, oldID or City. These are currently in a combobox. The second combobox, I then want to be populated with all possible entries dependent on first choice. So if they pick city I want the combobox to list all cities, and if they pick ID I want it to list all of the ID in the system. I don't really know if this is possible, I know you can base the contents of a combobox on a previous combobox if you know what field the user is picking from, but not how to specify the field from which to select.
Once the user has e.g selected city from the first, and melbourne from the next I want the third combobox to display all corresponding records i.e. where city = Melbourne.
If this made sense to you, is it possible, or do I need to implement 3 different sets of comboboxes to achieve this?
Thankyou
Steph
The user must choose their criteria by which to search either ID, oldID or City. These are currently in a combobox. The second combobox, I then want to be populated with all possible entries dependent on first choice. So if they pick city I want the combobox to list all cities, and if they pick ID I want it to list all of the ID in the system. I don't really know if this is possible, I know you can base the contents of a combobox on a previous combobox if you know what field the user is picking from, but not how to specify the field from which to select.
Once the user has e.g selected city from the first, and melbourne from the next I want the third combobox to display all corresponding records i.e. where city = Melbourne.
If this made sense to you, is it possible, or do I need to implement 3 different sets of comboboxes to achieve this?
Thankyou
Steph