Hello: I have a form with perhaps 50 fields, which describe a new contact and various attributes of their business. Now I want a second form that allows me to look for a record in the first table optionally by various fields, such as 'BizName', 'LastName', 'ZipCode'. So I can find the record by whichever piece of data I have.
When I select the correct record, I want to see many of the other fields from the original form displayed on this new form - so I can update them from here if needed, and so I can refer to those original form fields as I complete this new form.
The new form then, will have additional new fields to be entered into the new table, but which will of course also be related to the original record.
Could someone enlighten me on how this is done?
I see how to use a lookup field to select a record from the original table; but I'm unclear on, once the record is selected, how to display many of the other fields from the original form onto this new form. In otherwords, if I select 'BizName' from a drop down lookup field related to original form, then I want to automatically populate other fields matching that record from that table, such as perhaps 'FName', 'LName', 'Address', etc.
I hope my question is clear.
TIA for any help.