Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

Downline that goes multiple generations


This topic is 5277 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

This topic is 5277 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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