2 Replies Latest reply on Mar 15, 2016 5:57 PM by dgreensp_1

    Reference Multiple Records

    dgreensp_1

      Here is my issue:

      Table A and Table B are related by Name

       

      Table A: Permission Forms

      Record 1 - Bill Smith is attending Field Trip 1

      Record 2 - Bill Smith is attending Field Trip 3

       

      Table B: Student Names

      Record 1 - Bill Smith

      Field:  Field Trip 1 - This should be checked off as attending in the layout for this Student

      Field:  Field Trip 3 - This should be checked off as attending in the layout for this Student

       

       

      The problem is in Table B it is showing me that Bill Smith is attending Field Trip 1 but not Field Trip 3.  It is only pulling the data from the first record in Table A and not record 2 as well.  Is there a way to do this where it looks for all the records in Table A showing Bill Smith and checking off both fields for Field Trip 1 and Field Trip 3 as attending?