On Thu, 17 Jan 2019, David G. Johnston wrote:
Off the top of my head (and this is a model I am quite familiar with even if I'm doing this email at speed):I'd suggest an actual activity table:
David, Adrian's suggestion of a Contacts table column called 'active' having a boolean data type seems to me to be more compact. Testing active = true as a condition in the WHERE clause will display only those People with active contact needs. Thanks very much, Rich
