Topic: Filter search question
Hey guys.
Is there any way i can do an exception on search?
For instance, i have two combo boxes on a record.
I want to search for everything that is on combobox1, but if combobox 2 has a value of 2 for instance, it can show up on that same record if combobox1 has a different value than the search button)
Eg:.
I want to search for people that live in Lisbon only
But if there's someone that lives in oPorto city, but is visiting Lisbon, i want it to show up on that search too...
ComboBox 1 - Lisboa , Porto, Braga , Etc....
ComboBox 2 (Visiting) - Lisboa, Porto, Braga, Etc...
IF Combobox1 - (not lisboa) and Combobox 2 Lisboa then show record.
How do i put this in real practise?