Duplicating Tables

[nick_jp]

Hi,

Not sure if this is the right forum.

I have to add in temp tables to an existing solution, to improve data security.

I cannot see a duplicate button on the table definition screen. Is there a way to duplicate and avoid having to declare all the fields (1500+)

Thanks,

Nick

[Søren Dyhr]

You need fm8.5 or 9 adv.for that, I'm afraid!

Is there a way to duplicate and avoid having to declare all the fields (1500+)

Your solution should be redesigned and normalized anyway, the field/table ratio seems utterly wrong!

--sd

[nick_jp]

It's not one table, many tables :-)

The original solution (which I have inherited) did not backup records before editing, so anything is permanent. I want to add in backup tables for some features. Rather that defining each field by hand, wanted to know if there's a way I can "copy" tables and remove the fields that dont need to be backed up. This would save me a lot of time.

Thanks

[CobaltSky]

Is there a way to duplicate and avoid having to declare all the fields (1500+)

Hi Nick,

Yes, there is.

Since the release of FileMaker Pro v8.0, it has been possible to import a table, simultaneously creating the table and filling it with data.

To do this, choose File>Import Records>File..., select the source file, then from the drop-down menu at the top right of the Import Field Mapping dialog, select the option (second from the bottom) for "New Table...".

This does not require the "Advanced" version and you can use this technique to duplicate tables within the same file or between files (depending on what you select as the source for the import). :wink2: