I have two lookup fields on FORM1 pulling information from FORM2. I would like it if these fields could lookup each other.
Example1: If a customer service representative knows the
customer number and selects the number from the Customer_Number field on FORM1 then
On User Input would pre populate with the information from FORM2 into the Customer_Name field on FORM1.
Example2: If a customer service representative knows the
customer name and selects the name from the Customer_Name field on FORM1 then
On User Input would pre populate with the information from FORM2 into the Customer_Number field on FORM1.
FORM1
Customer_Number (lookup Field)
Customer_Name (lookup Field)
FORM2
Comapny_Number (Text Field)
Company_Name (Text Field)
I have found some similar old posts on this forum, but have been unsuccessful in my attempts to accomplish this feature.