I’m struggling a bit with linked records and getting the required data for them.
Let’s assume that I have a contacts table that list different contacts by a contact ID.
I have another table that I record every communication I do with a contact. The fields are: contact ID (same ID as in the contacts table), date, type, remarks, etc…
Now, since there are various communications with each contact, there are many rows (or records) with the same contact ID, one for each communication.
I want to add a field in the contacts table that would show the latest communication date for that contact. I couldn’t find any way to do that. What am I doing wrong?
Thanks a lot.