Imports are one table at a time and do not import relationships. Relationships linking tables in Manage | Database can only be created/changed manually. They cannot be scripted.
A single script can certainly import data from more than one file and/or into more than one table using a series of import records scripts, but I wouldn't describe a script importing data into three different tables as "a long drawn out script" unless there is some additional processing of the imported data needed--such as assigning match field values to newly imported rcords.
Thanks Phil. This is kind of what I was thinking. If I'm following you correctly, I simply should write a script that imports:
importclientIDTable to currentclientIDTable
importclientTable to currentclientTable
importpolicyTable to currentpolicyTable
My issue with this process is, when I'm playing around with the import function, it doesn't allow me to add records to the currentclientTable. it only allows me to add records to a new currentclientTable_2 instead. The only table not grayed out is currentclientIDTable. Is this normal?
To manually import records in to TableA, first go to a layout based on TableA. Selecting a layout also selects the target table for your import.
But if you set up Import Records as a script step in the script editor, you will be able to use this target table drop down to select a target table no matter what the current layout.