AnsweredAssumed Answered

Need help displaying related field information on a form

Question asked by bokenrosie on Apr 12, 2014
Latest reply on Apr 22, 2014 by philmodjunk

Title

Need help displaying related field information on a form

Post

     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.
      
      

Outcomes