I have the following tables/relationships:
Estimates < Line Items
Projects < Assignments
When an Estimate is approved, I have a URL button that will run two separate API_RunImports. Information from the Estimate will get pushed to create a new Project and info from the Line Items will get pushed to create new Assignments.
I can create the Project from the Estimate fine. My problem is properly linking the new Assignments to the new Project if a RecordID# has technically not been created yet.
From my understanding, I have to create a new key field besides the RecordID# on the Project table and then create a formula field on the Assignment table that would force the Project key field in there (or something like that).
I'm just looking for a little guidance/clarification.