I have a New Form which looks-up the ID from another form to create a relationship. I then want it to pull in data from the other form to fill some of the fields on the open form. I have tried writing the script in various ways but it keeps throwing up error in line 1 or 2 (if I leave the ; off the end of the first line it throws up an error for line one and if I include it as per below, the error is on line 2:
if (count(Students [ID1 == input.Team_Member_ID]) >0);
{
getrecords= Students[ID1 ==input.Team_Member_ID];
input.Full_Name == getrecords.Full_Name;
input.Tournament_Belt == getrecords.Tournament_Belt;
input.Date_of_Birth == getrecords.Date_of_Birth;
input.Male_Female == getrecords.Male_Female;
input.Height == getrecords.Height_CM;
input.Weight == getrecords.Weight_KG
}