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.commark.shnier@gmail.com
------------------------------
