I have created two custom objects (A and B)and a junction object(AB). i.e. Both A and B have Many to Many relationship. Now I need to insert 5000 records. How can I automatically populate the relation in Junction object. DO I have to write any trigger or Do I have to do Manually mapping the records?
[SalesForce] Many To many for Bulk records
Related Solutions
Look at the following image I found on search engine:
Here a team member is related to project. So there can be two scenarios:
- A team member can be related to multiple project
- A project can have multiple team members
To achieve this we create a object which will have reference to team member and project to establish relationship. Let's say the object name is: Project Team Member
So, for the scenario 1 you can create multiple "Project Team member" records which will have different team member in each record but same project reference. This way a team member can be related to multiple projects
For scenario 2, you can create "Project Team member" record which will have different Project reference but same team member reference.
This way multiple team members can be related to single project as well as with multiple projects and vice-versa. The best way to understand is do it practically you will understand how it is many-to-many relationship.
Best Answer
The best way to achieve this is by using the data loader. I would recommend using www.dataloader.io since it is infinitely easier to use and it contains a nifty feature that will make your life easier.
Dataloader.io allows you to "lookup" related records based on a certain field, so for example:
Say you wanted to create an account via dataloader and wanted to set the OwnerId field, but you only have the email of the user you want to be set as the owner. You can configure Dataloader.io to actually do a lookup of the user id based on the email, saving you the extra step of massaging the CSV.
To be more specific to your example, I would:
You can read about how to use the lookup feature here: https://dataloader.io/using-import-lookups
Hope this helps!