AnsweredAssumed Answered

field that searches/references multiple related records?

Question asked by accontractors on Oct 1, 2018
Latest reply on Oct 1, 2018 by fitch

I have two tables - Appointments and Customers, linked by a HomeownerID.  Each Customer will have multiple Appointments.  These appointment records include the date, time, type, and result.

I am looking for a way, in the Customers table, to search/reference the Appointment results and if one of the "results" equals "Sold" then the Customers table field will update to "Sold", otherwise will show as "Pending".  Each customer will have multiple appointments, in almost all cases the "Sold" result will be on the latest dated appointment record.

I'm not sure how to set this up, so that I am referencing/searching multiple related records?