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.

Downline that goes multiple generations

Featured Replies

I have a database that shows employees and their managers as well as a table that shows accounts and who started the account(or who it belongs to). On the employee's table there are two portals that display all employees that employee manages as well as a portal to display all accounts that belong to them.

I have figured out (with the help of this site) how to toggle the displayed data in the portal from just the info related to the current employee record or to display all of the managers and accounts that are in there immediate down-line.

What I would like to do is be able to toggle the displayed data from current record data to all records downline. For example if one employee (we'll call him EMP1) had 5 accounts and he managed 10 employees that also had 5 accounts each and also managed 10 employees each with 5 records....the original record's (MR. EMP1) accounts portal could show 5 accounts (if current records related records radio button was chosen) or 105 records shown of their entire down-line. This would continue all the way down-line. Hope this makes sense.

One last thing.....Could someone show me how I might accomplish the same thing but with the list() function? I was told this would be cleaner but I'm not very knowledgeable about this function.

I have attached the sample file

test.fp7.zip

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.