Forum Discussion
ColinBurns
2 years agoQrew Member
Got it thank you.
------------------------------
Colin Burns
------------------------------
MarkShnier__You
Qrew Legend
2 years agoColin,
A simpler way is to use a "Reverse Relationship". The Parent table knows the Maximum of the Record ID# of the Children. If you make a reverse relationship where one Child has many Parents and use the field best called say, [Record ID# of the Most Recent Note] ... ie you summary max field. ... as the reference field on the right side for the reverse relationship, the you can "lookup" easily any fields you like up to the Parent such as the most recent note, who entered the note ie the [Record Owner], the Date Created of the most recent note.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------