Multiple value search
Please advice if there is a way to search data from a field in a table to another table. eg
Table1 is use for property registration with the property title number inputed in the "Title" field, with data e.g T1234 or V4325 or T5243.
Table 2 is use when payment is made by cheque with the "Description" field for all the property title assigned to that cheque number e.g V4325, T1234.
How can i search for all the records in Table1 that have either V4325 or T1234 so that i can update the status field of the found set to "Paid".
Your suggestion will be very much appreciated.