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.

I need help understanding this kind of relationship - field\database\field

Featured Replies

  • Newbies

I don't understand relationships like this. Instead of just the name of the related database there is a field, a backslash, then the name of the database, another backslash followed by another field. Here is a picture of an example.

How are these relationships created? Why are they used? Can anyone point me to an in depth reference that covers them?

 

What you're describing (and showing in your screenshot) is not a relationship; it is the name of a table occurrence (TO for short), which is an instance of a table, used (among other things) to create a relationship by relating one (or more) of its fields to those of another TO.

A TO can have the same name as its base table, but doesn't have to; within certain constraints, you're free to choose a (unique) name. Usually, that name conveys something about the base table and about the context and/or purpose of that TO within its solution – as, presumably, does the name of the TO in your screenshot.

Note that in FileMaker, a relationship itself does not have a name. 

I suggest you open the FileMaker Help (or get another resource, e.g. the FileMaker Training Series) and study the introduction(s) to the how & why of creating table occurrences and relationships. Understanding TOs is fundamental to developing in FileMaker.

Edited by eos

  • Author
  • Newbies

Thank you! OMG having the right term has made my day so much better. I will check out the FileMaker Training Series.

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.