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.

Moving Fields to different tables?

Featured Replies

Is it possible to move a field to another table after its been created and assigned to a certain table? The reason I'm asking is because when I made the current database I'm using, I just put every field in one table, and now I'm wondering if it would have been more prudent to divide my fields into several tables. (Right now I have like 85 fields in one main table).

You're right some kind of normalizations measures should have happened along the proceedings. But what you ask for is not part of the regular version of filemaker but the developer/advanced ...so the sad message is if you can't lay your hand on one of these, are you bound to do it the tiresom way - because the reasoning is correct, usually are 75 fields in one table a sign of a poor relatioal structure.

--sd

As Soren says, there is no way to automatically move a field(s) between tables. However, the issue is not the number of fields, which at 85 is not unusually large, but the relationships of the fields in that table. Are they related or unrelated? Without knowing what you're really storing there is no way to comment.

Steve

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.