Child to Child Lookup / Relationship

I think, I understand.  You seem to need to be able to flat up text information from children up to the Parent to either use on a Report on the parent table or to look up down to children.

You can use the relatively new Combined Text Summary field for this.

Make a single formula field on the Milestone Table  and be sure to make it sort in the correct sequence like this

List(" ", "Milestone: " & ToText([Milestone#),
[Milesone Name],
"S/B date: " & ToText([Should be competed by]),
"Act date: " & ToText([Actually completed]))


Then use a combined text summary field to float up that text to the Parent Project.   You may want to have the filter omit Milestone 4.    Call the field  [Combined Text Summary Milestones 123]

Then you will see that the fields appears in a bubble format (although it is clickable as a link).

If you want nicer looking text  you can do this as a formula text field.

SearchAndReplace([Combined Text Summary Milestones 123]," ; ", " \n")

Then you can look that up down to your milestone table and use it on reports.

 

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------