how do I duplicate tables?

[FMnewbiePRO]

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

[mr_vodka]

You will need FileMaker Pro ADVANCED for that option.

[jstaphse]

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.

[comment]

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.

[FMnewbiePRO]

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

[comment]

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.