1 of 1 people found this helpful
Such a block move of records from one table to another is often a sign that you have a less than optimum design for your database. While there are exceptions, it's generally a better idea to keep such records all in one table. But what you want to do is pretty straight forward.
If the file with the source table is open (as it must be when both source and target tables are in the same file), Import records does not import all the records in the table. It imports all the records in the source Tutorial: What are Table Occurrences? found set. To import just certain records from that source table, perform a find, use Go to Related Records or some other process to produce a found set of just the records you want to import on a specific layout. (This, can be part of your script in most cases.) Then set up Import Records to import from the same table occurrence as the one named in Layout Setup | Show Records from. When you use Import Records to select this table, first select the very same file that you have open, then select this table occurrence.
Since you are importing this found set. You can use the script step "Delete all records" to delete them after you have imported records.