AnsweredAssumed Answered

Need status field to indicate yes/no the return of a questionnaire

Question asked by dicksmith on Feb 4, 2011
Latest reply on Feb 4, 2011 by dicksmith

Title

Need status field to indicate yes/no the return of a questionnaire

Post

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?

Outcomes