Need help displaying related field information on a form
I have a layout that needs to select and display contact information. The contacts are kept in two related tables (Company) and (Contact). Each Company can have multiple contacts.
As you create a record in the third table (notices) I want to be able to search for a contact from the above tables in a portal or search box and then have it copy related contact and company information to that third table. I don't want to link the related information, it has to be copied because contacts sometimes change but the notice record should remain faithful to the calendar and how it was when created.
I have built out the notice part. I have built out the contact/company part. Now all I need is a way to get info copied.
Any help would be greatly appreciated.