I have a table that I want to search for data inputted by a user and then find another field to then search for. It would give me a broader search than the user inputs.
table1
ID
LocationID
CityID

table2
locationID

table3
CityID


Basically a user inputs possibly a suburb of a city so I then want to be able to find the suburbs city and widen the search to include the city.

Therefore possible combinations are

<u>LocationID -------------------- CityID</u>
Armley ------------------------ Leeds
Leeds ------------------------- Leeds