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.

Copy/import a table without recreating fields?

Featured Replies

  • Newbies

Is it possible to either copy a table (with or without the data) within the same database or to import table data to a new table without having to retype/define every field again?

I'm quite sure it's not possible but I find it hard to understand why you would want to do this.

You can add multiple occurenses of the same table by using the relationship graph.

File > Define Database > relationships

Maybe this is what you want?

This is almost correct what David says, with one exception "Import between tables" to allow the splitting of repeating fields into separate records.

But is it a particular hard task to recreate a fairly well normalized structure??? no! - since a table having a lot of fields in one table isn't particular normalized - even though calcfields keeps creaping on you as a cheep coat as soon you lack the attention - lets call it the speadsheet syndrome.

Lets talk of the the nature of the table involved, the relations and the scripting involved - at first sight does it look like you're barking up the wrong tree - especially the fieldnumbers could be turned otherwise, if you pay attention to the reasoning behind this movie:

http://previews.filemakermagazine.com/videos/513/DataTagging_full.mov

--sd

  • 3 weeks later...

Actually, I'm looking for an answer on this one as well...

FM "locks" tables into a database structure, which means that if you create a table in one database, you can't use it in another database. Creating references to other tables in other databases is *not* the same thing.

It seems the only way to create tables in FMP is manually. That's really lame.

So I'll ask the same question again, since it hasn't been answered:

Is there a way to copy a table structure from one database to the other?

Is there a way to copy a table structure from one database to the other?

You can use a third party tool like FM Robot or FM Migrator. But other than for consolidating files, I don't see a good reason to copy tables. It's usually not a good structure to have multiple similar copies of the same table within a file. I think this is what David was getting at.

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.