1 2 Previous Next 24 Replies Latest reply on Jul 21, 2017 2:45 PM by ddave

    Displaying related records on parent table without using Portal



      I have a parent table called "Customer" and related child table "Contacts".


      I want to display related Contacts on parent form layout as below:


      1. "ContactName" as drop-down value list showing all related contact names

      2. Once I select a name, it should auto-populate other fields cell, email, title etc.


      I have tried using two occurrences of "Contacts" table relating to "Customer" table, first "Contacts" is related through two related fields  (pk - fk) & (contactFullName-contactName) and the second "Contacts 2" (pk-fk) where I allowed creation and deletion of records in "Contacts" table. On the other hand , I created equivalent fields in "Customer" table to fetch "Contacts" information which all are set as "auto-enter" through lookup in their corresponding fields in "Contacts" table for eg. contactDirect(Customer) looks up value in direct(Contacts) field. I placed these fields on the form and set "ContactFullName" as dropdown field which uses valuelist from contactName (Contacts Table) But that approach didn't work out.


      Screen Shot 2017-07-21 at 9.20.12 AM.png


      Attached is the working solution if someone needs it in future. Thank you everyone for your time.

        1 2 Previous Next