move fields into new table
Is there a way to move lots of fields into a new table without having to re-write each field?
With Filemaker Advanced, you can copy and paste them.
Without FileMaker Advanced, you can't, but there is a way to use Import Records with the new table option to duplicate an entire table so if you haven't yet created that table, you could duplicate the table from which you wnat to move the fields and then delete the fields you don't need.
In neither of these scenarios have you moved the data--just the field definitions.
I assume that to do this I will need to make a clone database. Thanks I will give it a try.
Not necessarily. You can import from the same file into itself.
Retrieving data ...