I’m so glad you were able to get to this point! These next steps are pretty straight-forward and hopefully will help deepen your understanding of how to make the database work for you. Knowing how to search for the info you need will often reveal whether you’re using an efficient structure. Currently, I think you are
To display Marta’s Manager’s name:
Do a search for Contact. Add a constraint PersonID = Current Page Contact’s ManagerID. Then take the first item of this search. Then grab the Full_Name field. The full expression for the name text should read “Search for contact’s:first item’s full_name”
The constraint is pretty self-explanatory - you’re looking for a contact whose PersonID = Marta’s ManagerID.
The reason you need to grab first item is because when you “do a search…” it is returning a list, even if you know only 1 contact meets the constraint, so you’re specifying that you want the single result.
To display Contacts managed by Marta:
Use a repeating group to display this list. A repeating group is set to have a list source, and each cell displays each item in that list, so the job here is to make sure your source is set correctly. It will be pretty similar to the expression for finding Marta’s manager.
Do a search for Contacts. Add the constraint: ManagerID = Current Page Contact’s PersonID. And that’s it! So, now, we do want a list, so this is going to return all contacts whose ManagerID = Marta’s PersonID
Now, in the first cell of the repeating group, add 2 text elements (you could also do this within 1, but for more control of spacing, I’d use 2). 1st text element: Current cell’s PersonID. 2nd text element: Current cell’s Full_Name. You’ll see that that you only need to do this for the first cell, and the rest of the cells will follow suit and display those fields for their cell’s contact automatically.
Let me know how this goes!