[SalesForce] How to enter multiple contacts in one custom object

I created a custom Object "Visit Reports" and would like to be able to pick all participants from the Standard object Contacts.
I have entered several "Participant 1, 2, 3,…" lookup fields to Contact.

In Contacts I get a related list to each Participant Field.

What do I have to change to get in the Object Customer just one related list, showing all "Visit Reports" were the contact is named in one of the participant fields?

Or is there different solution?

Best Answer

Create a Junction Object. It will solve your problem. Create a Junction between contact and Visit Reports. And then create Many to Many relationship. In this way you have only one related list with multiple Contacts.

Related Solutions

[SalesForce] How to get the custom fields from a custom object

You can use Dynamic Apex to perform describe call on object for which you want to get meta-data as described in below example:

List<String> fields = new List<String>();
fields.addAll((Event__c.SObjectType.getDescribe().fields.getMap().keySet());

Above code will return all fields of Event__c Object which will get stored in List of type String.

Best Answer

Related Solutions

[SalesForce] How to get the custom fields from a custom object

Related Topic