I have a master object - Employee and its child object - training. The training has below fields:
Name
employee - reference to master
I am using data loader to insert the records in training object. The csv has columns name as Name - course1 and employee- Mark. I do not have ID of mark in csv file. This a specific scenario. I have to query Mark's(employee) Id and populate it in the employee field
on training so that the record can be saved.
Is there a way to do this? is it possible to do this before insert trigger that I can query the employee id based on the name given. Any suggestions? I do not have option to pull the id in csv file.