AnsweredAssumed Answered

Multiple value search

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

Title

Multiple value search

Post

Hi, 

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.

 

Thanks

 

Ray

Outcomes