Two Table Folder Tree

[Dr. Evil]

Is it possible to display in a portal - Parent Record with Children Records below it?

For example:

Parent One

---Child One One

---Child One Two

---Child One Three

Parent Two

---Child Two One

---Child Two Two

I have seen some articles on how to do this with ONE table... but not TWO tables involving Parent and Children.

My ultimate goal is to build an "Overview" portal on the Parent layout so user could see Parent and Parents children on the fly vrs. generating a report. Used as a navigational tool as well.

I already have this built showing only the given children records. I could just show the related Parent in the same row... but it looks hacky and redundant. I don't want to list Parent Name over and over, just once with children neatly tucked under it.

ANY HELP? Thanks :)

[Matthew F]

I'm not quite following. Maybe an example file would help?

[comment]

Is it possible to display in a portal - Parent Record with Children Records below it?

Well, it's not entirely impossible - but ...

A portal can show records from a single table only. Although you could use a third table as a "display table" for the other two, you would have to make sure that the portal shows exactly the required number of records (number of parents + number of children) and in the required order (parent, children, parent ...). All together, it's quite an undertaking.

I don't want to list Parent Name over and over

Have you considered showing the parent only in the first row of the group:

http://www.fmforums.com/forum/showpost.php?post/266405/

[Dr. Evil]

mfero: I have attached a sample file.

comment: I used your technique in the sample file. Nice solution. Clean and simple. The only downfall I see is the wasted real-estate in the portal row.

The idea of a join table to display info sounds interesting... but don't the benefits if any.

Awesome feedback Fellas. Thank you.

PortalTrick.fp7.zip