Need status field to indicate yes/no the return of a questionnaire
I have the MEMBERS table, the MINISTRIES table, and the join table MEMBERS_MINISTRIES. A subset of members have returned a questionnaire, the results of which are entered into the join table through a portal. I'd like a status field in each member record to indicate yes/no whether they've returned the questionnaire, based on the presence of their _member_id in the joint table. How best to do this?