2 Replies Latest reply on Feb 4, 2011 1:49 PM by dicksmith

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

    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?