Hello,

I'm new to Skyvia and I recently encountered a need to import MySQL data into a Salesforce organization.

Currently, I have the following situation and relationships established:

1.  Opportunity
   
2.  Object/Table A with a foreign key, OpportunityID, to connect to an opportunity.
   
3.  Object/Table B with a foreign key, OpportunityID, to connect to an opportunity.
   
4.  Object/Table C with a foreign key, OpportunityID, to connect to an opportunity.
   

To address this, I've created a new object in Salesforce named "Capability Inquiry," which will serve as a bridge between Opportunities and A/B/C. Consequently, the updated relationships will look like this:

1. Opportunity
2. Capability Inquiry: This object's data will comprise partial information from an opportunity and will possess a foreign key, OpportunityID, to connect to the opportunity.
3. Object/Table A will have a foreign key, CapabilityInquiryID, to link to the Capability Inquiry object.
4. Object/Table B will have a foreign key, CapabilityInquiryID, to link to the Capability Inquiry object.
5. Object/Table C will have a foreign key, CapabilityInquiryID, to link to the Capability Inquiry object.

Progress update: I've managed to import data into Salesforce opportunities and create Capability Inquiry objects along with their respective relationships.

My query: However, I'm unsure about the process of obtaining the generated Capability Inquiry ID for A/B/C. I tried to use "Target Lookup" so the A/B/C can find the Capability Inquiry ID through its OpportunityID and the opportunity record because so far one opportunity only has one capability inquiry object.

I would greatly appreciate any advice on how to proceed with this.

Thank you,