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.

Relationships & Auto-Filling

Featured Replies

HI. New to FM. I'm understanding many of the basics, but not getting some. Here's my dilemma:

I have a table of physical fitness test scores within 6 tests: (mile run, etc...). Each test has a preferred range of scores (a hi-value and a lo-value). These value's change depending on two variables: gender and age of the student. So I wrote a table (I call "Standards") that recorded the age & gender and the corresponding values for them in the various fitness tests.

Now, I create another table ("Students"):( I create age/gender fields that the user selects from a drop-down list and fields with same names as the hi/lo scores. I made these fields (the fitness scores) as Lookup fields, referring back to the other table (Standards).

Now my problem: when I test this table (Students) in Browse mode, the fields for the hi/lo scores (that refer back to the other table (Standards) do not change, and remain blank when I enter info in the gender and age fields.

I was expecting these to automatically enter the corresponding values from the "Standard" table when I enter an age & gender.

Any suggestions?

--Mark

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.