Need to See Details of Child Records in Parent Table

Question

I have a parent table Contracts and need to see the values (text) from 1 of the child records (whichever record has the checkbox filled in the field "Active Contract?") for the child table Contract Versions.

I need to bring up 3 values from the child table, Start Date, End Date and Amount.

Can someone help me think through how to establish a reverse relationship to pull these values to the parent table? I've done this before but I'm having trouble thinking through the exact steps and in which order and it looks like the answers to my old questions have been lost when the discussion forum changed to a new site. And I haven't yet found anything in searches which covers this.

Thank you!

------------------------------
Amber P
------------------------------

MarkShnierYou · Answer

OK so in the "old days" I used to do zillions of reverse relationships. Now I'm doing to virtually never as we now have the new functionality called the Combined Text Summary field.

But in your use case, it would be a bit annoying to use that as all your fields are not text fields.

So to do a reverse relationship make a summary field to calculate the Maximum of the Record ID# field subject to the filter that the Active checkbox is checked. Call this field [Record ID# of Active Contract Version]

'The make a backward (reverse) relationship where 1 Child (Contract Versions) has many Parents (Contracts). When you make that relationship, do not let it create a new field for you as the "reference field", but rather select the field that you will have named [Record ID# of Active Contract Version].

Then just look up those three fields from the lucky child Contract Versions who was the most recent Active Contract version to the Contracts table.

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

Sign up

Login to the community