How to import records from one table to another in the the same database
I'm importing raw SWIFT message types into a table on my database. Currently I have to export all of the cleaned up records of this table to an external FM file reimport it to my main datable in a different table.
Given that we only have three FM Pro 12 users and no server version, only the person that signed on first and shares the DB can run these export/import scripts. All scripts run with full privileges but unless the first signed in person runs the scripts I do get error messages.
Therefore, I hope to be able to do this internally by importing the records from the raw (first) table directly to the second table within the same database.
Is that even possible in FM12? Thanks!