I have created a form to allow customers to register at an open house at work. However I am trying to figure out a way to automatically fill certain fields if two customers from the same company come and one has already registered. For example; if john smith from company xyz came to register and bob brown from the same company had already registered, once john smith entered in xyz in the company name field it would automatically fill in the company's address, city, street, zip code, phone number, and fax number based on the information bob brown gave when he registered. Is it possible to do this without having a company list already created for it to reference? Please help and let me know if this is not clear.
Thanks,
Kyle