hello Developers,
This is related to one of the requirement to import the data into multiple tables 🙂
I have the excel in which I am having 9 fields with the data but these 9 fields data does not belongs to one table , these belongs to 3 different tables.
so basically I need to import the data into the data into 3 different target tables.
Here is a challenge these 3 targets tables are inter-linked to each other means they have the parent - child relationship.
Target tables are
1). Contract->Expense Line
2). Contract -> Users covered
expense line have a reference field for contract record
User covered record also have a reference for contract record.
My challenenge here is - while importing the data which needs to be imported in 3 target tables..
how should I set the relationship between them..
Firstly contract record will be created then expense line and then contract and user linkage to done..
Please help with the approach to link the target records while importing.
Thanks !
