I am trying to input a field in a subform depending on whether or not another form (Complete_a_Waiver) has previously been completed with the same first name, last name and DOB as the row in the subform. If yes, then it will input as yes, if no then it will input the field with no. I have tested with the below script and it is inputting No when I have a record in the other form with the same first name, last name and DOB.
Can anyone tell me what I am doing wrong with this script?
count = 0;
fetchRec = Complete_a_Waiver[Participant_s_Name.first_name == input.Attendee_List.Guest_Name.first_name && Participant_s_Name.last_name == input.Attendee_List.Guest_Name.last_name && Participant_s_DOB == input.Attendee_List.DOB];
if(fetchRec.count() > 0)