1 2 3 Previous Next 35 Replies Latest reply on Jan 26, 2017 7:14 PM by peakest

    Script for Related Set help please

    peakest

      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.

      TOG Extended Takeoff.png Takeoff.png

      The TAKEOFF DATA is needed to get each TAKEOFF DATA row's BUILD DETAILS (through the related BUILD) as script/import/lookup.

      TakeoffData.png

      Here are the BUILD DETAILS:

      BuildDetail.png

      Here is the target table for the import/script new records Extended Takeoff Details (shown from Excel):

      ExtendedTakeoffDetails.png

      I am at a loss in finding the IDf_BuildDetail(s) for each IDf_TakeoffData via the related IDf_Build.

        1 2 3 Previous Next