Skip 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.

CDML, Relationships, and Valuelists

Featured Replies

  • Newbies

I've got a problem pulling up a pop-up list. It is similar to a more easily solved problem, but I can't get this one...

There are two databases, say District.fp5 and Learning.fp5. Among the many things I care about are two fields in District.fp5, Goals1, and Standards1. Learning.fp5 has only two fields, Goals and Standards. Each goal has several standards. (E.g., the records for the standards "take-off," "height," and "landing" might all have "jumping" as the goal.)

Goals1 is a pop-up, and the value-list is filled from the relationship between Goals1 in District.fp5 and Goals in Learning.fp5. Once Goals1 is chosen in the FMP database, Standards1 is a pop-up, and the value-list is filled from all of the standards in Learning.fp5 that correspond to the chosen goal.

What I've tried is:

<SELECT NAME='Standards1' SIZE=1>

[FMP-InlineAction: -db=Learning.fp5, -lay=list, -findall]

[FMP-Record]

<option value="[FMP-Field:Standards1">[FMP-Field:Standards]

[/FMP-Record]

[/FMP-InlineAction]

</SELECT>

but this merely returns the first 25 records from Learning.fp5 rather than the desired standards. (Yes, I kow that the inital option value is wrong, too, but I'm just trying to get started on this.

How should this be done?

Thanks!

Barney

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

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.