How can I create a table that is identical to another table, just with a different title? Is it necessary to type in all fields again?
Also, how can I make the new table "live" in the new document?
What version of FMP are you using? What I am posting works for FMP 10 and I think it will work for FMP 9...
You have a tool, called Import Records in your file menu. This tool can be used to duplicate existing table definitions. You may also be able to copy and paste table definitions from Manage | Database depending on which version of filemaker you have.
Using Import Records:
Filemaker will now create a new layout that refers to your new table and imports the table into your file.
You can now use Manage | Database to rename the table and build relationships as needed to use your new table.
Using Manage | database
This method copies the field definitions but creates an empty table. I believe, also, that it's only available to FMP advanced users.
Open your source file
Note: Using both methods may deactivate certain calculation fields by turning their entire definition into a comment by enclosing the expression in /* */ symbols. This will happen when the expression refers to a Table Occurence that does not exist in the target file. You will have to either create a matching table occurence or manually repair the field definition before removing the comment symbols in order for these field definitions to become functional.
Hope that helps.
Wow - thanks! I am using FMP 8, and am working on hosted databases. Does that make a difference? We have 4 hosted databases. I want to create more tables within one of the databases.
Select the import records option and see if theres a "new table" option in the target menu.
Retrieving data ...