Copy/Duplicate table structure
I want to create a new table as a copy of an existing table structure but empty of records.
Using FilemKer Pro 10
Can I do this and how?
I might be wrong about this but I think that copying of tables can be only achieved using FileMaker Pro Advanced.
If you go to File>>Manage>> Database... in the Tables tab you can Copy and Paste the table which will have no records. Hope this helps.
Probably you can notice the extra buttons [Copy] [Paste] [Import...]
Thanks. You may be right. That screen view is not the one I see in FileMaker Pro 10.
All I have is Create, Change or Delete.
What a pain! Why on earth make that an 'advanced' function you have to pay even more for.
Thanks. Guess I'll have to do it the hard way.
You can import the table into a new table then delete out the records.
Mr_Vodka is correct. When you specify the target table during the import, look to the bottom where it says 'New Database.' BTW, if you open your source table first and Show All Records and then Show Omitted, you will have an empty found set. Leave it open. Then go to your new file and File > Import. When you import by Mr_Vodka's method (and specify new table at bottom from the target popup), you won't have any records but the field names and structure will come over.
Retrieving data ...