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.

newbie key confusion

stardust
in Relationships

Featured Replies

Hello everyone,

I am relatively new to FM and some of the db terminology. Could someone please explain to me the terms "primary key" and "foreign key"? I have gone through many of the forums and seen them referred to. Thanks in advance!

In simplest terms, the primary key is the field on the left side of the define relationships dialog box, and the foreign key is the one on the right.

The primary key is a field in the current (or parent) file that is used to select one or more records from a foreign (child) file. The selected, or related, records in the foreign file are those whose foreign key field values match the value of the primary key in the current file.

  • Author

Thanks for the clarification! Some of the posts I've been reading make a lot more sense now.

Create an account or sign in to comment

https://fmforums.com/topic/14950-newbie-key-confusion/
Go to topic listing

Important Information

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

I accept

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.