dgreensp_1

Reference Multiple Records

Discussion created by dgreensp_1 on Mar 15, 2016
Latest reply on Mar 15, 2016 by 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?

Outcomes