AnsweredAssumed Answered

Multiple value search

Question asked by RaynoldHenriette on Jan 26, 2012
Latest reply on Jan 26, 2012 by philmodjunk


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.