Well it really depends on what the excel ss look like, configured, and how you are trying to do the import
but it doesn't seem to work with the small number of crews I'm testing with.
What's working and what's not working?
Generally I would think of 2 approaches. Import all the info to a temporary table where it can be properly parsed out. Or multiple imports-first import and create the missions to the proper table. Then import the aircraft to a temp table where you can assign the proper foreign key. Then import the crew to the proper table related to aircraft.
And keep plenty of back up copies. Don't forget, after you do an import, you are left with a found set of records. Don't change that found set until you can verify they are correct. If the import is incorrect, you can delete that entire found set of records and try again.
Usually it's best to perform the import manually first, test, then test some more, then script the import and test and test
Steve: Turns out the problem was missing a field in my Join_Aircraft_Missions_Tbl called 'SelectedAircraft'. There's a script that runs to link a particular aircraft by ID number to the Join_Acft_Crew_Selected_Tbl. I'm still very new to the idea of using scripts to pull selected data, but I'm jumping in with both feet. I do have one question about scripts. On occasion I need to have two parameters in the Set Field command. When I try using the GUI to create a script, it only allows a single parameter. Can I create a script manually if I know the parameters needed? Thanks for your ideas and help.
I recently retired as a Systems Staff Test Engineer working for General Dynamics on a WCDMA based satellite waveform for a software-defined radio (military project) called MUOS. I'm very familiar with multiple tests and regression testing.
On occasion I need to have two parameters in the Set Field command. When I try using the GUI to create a script, it only allows a single parameter
What's a GUI?
Can you elaborate with an example. Do you mean 2 'thing's in one field, or 2 script parameters for a script? If it's the first, usually you set a variable, then set a field. You can set a variable to 2 things by appending it.
If it's the second, you can't set 2 script parameters, but you can set a multi-script parameter, then parse out the parts as needed.
Can I create a script manually if I know the parameters needed
Technically, all scripts are created manually, do you again mean hard coding a script parameter?
Steve: I think of a dialog box as a sort of graphical user interface or GUI. In this case it's the scripting Edit dialog that I'm referring to. Using the 'Set Field' command, I get Set Field  in the script steps display window. If I check the 'Specify target field' box and click on the 'Specify ...' button, I can select a particular table and field to set. Another responder on this forum, Guy Stevens, provided the script below which had two entries in the script and I was just trying to figure out how they were entered.
When Setting up Set Field, there are two Specify buttons that must be clicked. To get Set Field [Table::Field ; Expression], add set field to your script and click the first button (specify target field). Select Table::Field from the list of fields. Do not click the specify button next to the repetition box. Click OK to close this dialog box. Now click the lower specify button (calculated result) and create the expression to the right of the semicolon (;). Do not try to type in the semicolon.