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.

Sub Portal: Limiting View Based on Main Portal

Featured Replies

GOAL:  I would like to either click on a button within main portal and in doing so the Sub Portal FK activate those records that match the Portals PK.

CURRENT PROBLEM:  When I am within the Main Portal if I want to time-stamp PK record 6 I would have to manually type it into the FK.  In addition, it would get confusing because it is showing TimeStamps from both of the Main Portals PK.

HELP REQUESTING(Thanks in advance): I would like to write a script that when I click on a button within the Main Portal it only SHOWS those records within the sub portal that are related to that PK.

EXAMPLE:  Within Main Portal:{See Figure 1 below} I click on the red button.  In doing so, the Sub Portal only shows items with a FK of 6.  I am hoping then I can go to the last row and add a new time stamp within the Sub Portal should I choose.

THANKS:  I know your time is valuable and I am really an grateful.:)

FileMakerSubPortal.thumb.jpg.62bc212868e

****************************************************************************************************************************************************

FileMakerEXample.thumb.jpg.ed9164aa48ecc

****************************************************************************************************************************************************

FileMakerRelationships.thumb.jpg.03c2779

Edited by chuckcou

That's a rather confusing description. Did you mean something like this:

 

 

SelectedGrandchild.fp7

Edited by comment

  • Author

Yep, Exactly what I meant.  Looking over your code now.

Interesting Relationships.  gSelectedChildID?  Hmm don't get it totally.  I see g for global.  I will work on this in the morning, but yes you done it.  Thanks for the quick response, too

Edited by chuckcou

Hmm don't get it totally.

You will, it's not that complicated.

Here's another option, using a filtered portal. Note that here each parent retains its selection until the end of the session.

ViewGrandchildren11.fp7

  • Author

Thanks for the feedback.  Yep, I got it.  Thanks again everyone.

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.