Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

a way to copy a table into a new database?

Featured Replies

just curious...is there a way to copy an old table (i.e. the fields, or even a layout of those fields) into a new database/fm file?

otherwise, it looks like I will have to recreate fields over again, which is fine. just curious if anyone new if this is possible?

To copy a clone (no records) of a table, go to File-->Manage-->Database..., click the Tables button, highlight the desired table, and click the Copy button. Open the new database, go to Tables in the Database Manager, and click Paste. You can then import the records, if desired.

There is no direct way to copy a layout, but you can copy all the fields in layout mode, and then paste them into a blank layout in the new database.

You can then import the records, if desired.

You can also import the table into a new table, which will duplicate the structure AND bring in the data all at once.

  • Author

ok thank you! i tried to do that, but for some reason, i am not allowed to "copy" the table after going to manage database and clicking on the table i want to use. i will keep playing with it.

If you want to import the fields and data all at once (the easiest way to handle it), as Comment suggests, here is details of how:

Switch to ANY layout and begin a manual import. When the dialog opens, select your source on the left but on the right for the target, scroll clear to the bottom and it will say 'new table' and it will attempt to name the new table like the source. All mapable fields will map and all records will import and it will create the table as well.

So if you can't get the Manage Database method to work, you can import, creating the new table during the import itself and then delete the records back out. Or better, if it is a FileMaker file, just have the other file open and isolate to one record in the found set and perform the import. Then you'll only have one record to delete. :^)

Both techniques are very valuable.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.