Copy found set from one table to another with in same database
I am sure I have done his before in earlier versions but doesn't work the same in V12.
I have a found set in one table which I want to import into another with in the same file. I have an script that performs the find in the relevant table then imports using the import command with the file link poinitng to itself. Import works ok but everytime it imports all records from target not just the current found set.
I now have a workaround that exports to another file then reimports from that but this is messy and would prefer something more direct as file will eventually sit on FMP Server and be used by others.
Anyone any ideas?