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?