I have a form that uses a lookup to pull in Student Information (First Name + Last Name + DOB) based on a Student ID.
I also need to give the user the ability to enter the student's First Name + Last Name + DOB to do a lookup to get the Student ID.
Of course populating field(s) in one set of data changes the value in the other set of data which triggers a lookup and then that lookup populates the field(s) in the other set of data which triggers a lookup.... Infinite looping lookups.
Is there a way to prevent the second lookup from triggering? So if I type in the Student ID, I don't want the other lookup to trigger once the name and dob fields are populated. And vice versa.
I know I could ask if they have a Student ID and then use separate groups of fields populated from the lookup. I was just hoping to find a better way to do this.