I have a database that records information on the staff working in the building (over 400). This information includes the licence number of any vehicles (up to three) they might be parking in the parking lot. I have created three fields in the table to record the licence numbers of the vehicles.
My problem is that to search the table for a licence number that was recorded, unknown to me, in the third field, I have run the search three times, once for each field.
Is there any way I can setup a query that will check all three fields in one search request.
Alternately is there a way to set up the field so that it contains all three Licences numbers in such a way that a single query will find any one of them when a search is run for a single Licence number.
My problem is that to search the table for a licence number that was recorded, unknown to me, in the third field, I have run the search three times, once for each field.
Is there any way I can setup a query that will check all three fields in one search request.
Alternately is there a way to set up the field so that it contains all three Licences numbers in such a way that a single query will find any one of them when a search is run for a single Licence number.