Pull multiple fields from Form A into lookup field in Form B
In Form A I have 3 different fields, Contact, Contact 2, and Contact 3, plus Email, Email 2, and Email 3. In form B, I have a lookup field that currently will only lookup the value of Contact and auto-populate the associated email. In the lookup field of Form B I need to pull the values of Contact 2 and Contact 3 also (if value is present) into the lookup field. Is this possible?