Fetch and set variable. Please help
Here is my
scenario, I have one form called Palo Alto Records and it consists of
Phone number, business name, and address. The second form is called
sheet1 and it has Phone number, Phone number status, New Phone,
business name, business name status, and business name, address,
address status, and new address. In the Palo Alto Records form I have
imported many business phone numbers, names, and addresses. For the
second form I want to be able to put in the phone number and have the
records from Palo Alto go into the form in sheet 1. Then the person
can look and if the company name is correct they would just check the
correct box in company name status. If is is wrong then they would
check the incorrect box in company name status, and then go to add
company name and type in the new one and submit into the view. Is
this possible??