We have recently imported 2 data objects from an API call and was wondering what the best solution to connect these 2 objects is. We have a field in each that will be identical so we can match these in our external systems but was wondering how to get these 2 objects to connect automatically. What would be the easiest way to do this that won’t require manual intervention later? We are going to be having a lot of records in each object so manually assigning would be a lot of work.
The 2 objects are Agreement and Customer.
These are both to be connected on a field called ‘CustomerAltKey’ which is present in both objects.