Copy tables

[Saddletramp]

IS there any way to copy a table to put into another database. I tried Import it just brings in the format and the data but not the calculations in the calculated fields. I just need the Table Format and Calculations.

Thanks

The Tramp

[Ocean West]

Using FileMaker Pro Advance you can copy fields and associated calculations.

[Saddletramp]

I have FM advanced I haven't learned how to do this action yet can you give me an idea?

Thanks

The Tramp

[Lee Smith]

Take a look at the Manage Database Tool. [color:blue]Main Menu >> File >> Manage >> Database

With the Table Tab active, you can copy one or all of the tables, When the Field Tab is active, you can copy one or all of the fields.

[color:red]Oops, forgot to mention that you than need to open the TO and Paste the copied data.

HTH

Lee

Edited May 9, 2008 by Guest

[Fitch]

If you don't want the data, then copy/paste is easiest.

If you do want the data, import will do the job. In the Import Field Mapping dialog, set the Target to New Table. It will bring in all the fields, calculations included.

The dialog is a little deceptive, in that any field that is dimmed out (calc fields) or that you manually deselect, will still be created in the new table, it just won't bring in any data to that field.

[Saddletramp]

Thanks ALL, I got it

The Tramp