I'm reworking a solution I originally created as a flat file. I've now correctly redesigned the solution with multiple related tables with corresponding join tables where needed.
I'm at the point now where I'd like to begin importing records from the original flat file solution, but I'm unsure how to properly populate the related join tables. From what I've read, I realize that I need to have a layout for each child table and will need to begin the import process from each child layout.
I had planned on creating a temporary matching key for the separate parent and child records import, but with the join table in the mix it gets more complicated.