I know there is a button to duplicate a table under relationships tab in the DEFINE>DATABASE.

But, it duplicates a table under the original table and that's not what I want to do. I want to create an entirely new table with the same fields as my original table. How can this be done?

TIA,

Jerry

You will need FileMaker Pro ADVANCED for that option.

I don't have the regular version on my machine, but i think you can export, then import to a new table with the regular version.

You can import to a new table directly, without exporting first. The result is the same as duplicating a table, except the data is brought over as well - so you may want to reduce the found set to 0 before importing.

thnx guys for all the responses. Could someone explain how to import a table directly?

There's not much to explain: Go to File > Import Records... Select the same file as the source file, the table you want to duplicate as the source table, and a new table as the target table.