I need help with a script to create or import new records in a new table. Each TAKEOFF DATA row has an ID_Build which is related to one or many related BUILD DETAILS. I need the BUILD DETAILS for each TAKEOFF DATA ROW.
Here is the Table Occurrence Graph for these tables.
The TAKEOFF DATA is needed to get each TAKEOFF DATA row's BUILD DETAILS (through the related BUILD) as script/import/lookup.
Here are the BUILD DETAILS:
Here is the target table for the import/script new records Extended Takeoff Details (shown from Excel):
I am at a loss in finding the IDf_BuildDetail(s) for each IDf_TakeoffData via the related IDf_Build.