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.

Main Matchfiled: Autoenter Data vs calc field

Featured Replies

Context: Matchfield in a related file that is the same across all records to pull all records from one T.O. to another. One can do this with a text field formated to auto enter a data entry (eg: A) or a calc field with the calculation "a", and both set to save and index.

Question: is there an inherant advantage of one over the other. To my brain the calc field is nice in that if I decide to change the contents (for whatever reason), I don't have to do a find and replace as I would have to for the data auto entry.

Analogus issue: in the main file, I can use a global or calc field as a match field that is the same regardless of what record I am in but unique to each computer station on a network, (eg to make a relationship using the terminal name to pull the user's passwords, privileges, preferences...). Is there an advantage in using a setfield into a global for the MF or simply use a calc field (such as Get(UserName))? smirk.gif

In FMP 7 there is no need for this type of relationship. The X relationship does this.

In older versions I used the Calculation since the user can not change the value. Also don't use 1, use some random number.

  • Author

What is the X relationship. When defining relationships one can look down the pop down list and see the =, unequal, <, >, and X. Is this "X" what you are referring to? If so, what type of field do I specify and how is this field formated in FM 7? Thanks.

Yes that is the one. Just use the key fields of the 2 tables. It will match every record.

The choice depends on whether or not you want the user to enter the field.

  • Author

Will try it. Thanks.

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

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.