The Parent record will be a single record, the child records can be multiple. The child records are tied in the relationship via the record id of the parent. As for the max record ID there will be multiple parent records with child record(s), would the max still apply?
If your notes table is the child then yes, the max record ID will be the max Note Record ID of the notes related to that parent, that's the design of the relationship. So do the Max Record ID# of the notes and you have the RID of the most recent Notes entry that you can then point your formula query to.
Got it thank you.
Qrew LegendColin,
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.
The Parent record will be a single record, the child records can be multiple. The child records are tied in the relationship via the record id of the parent. As for the max record ID there will be multiple parent records with child record(s), would the max still apply?
The Parent record will be a single record, the child records can be multiple. The child records are tied in the relationship via the record id of the parent. As for the max record ID there will be multiple parent records with child record(s), would the max still apply?
If your notes table is the child then yes, the max record ID will be the max Note Record ID of the notes related to that parent, that's the design of the relationship. So do the Max Record ID# of the notes and you have the RID of the most recent Notes entry that you can then point your formula query to.
If your notes table is the child then yes, the max record ID will be the max Note Record ID of the notes related to that parent, that's the design of the relationship. So do the Max Record ID# of the notes and you have the RID of the most recent Notes entry that you can then point your formula query to.
Got it thank you.
Got it thank you.
Colin,
\nA 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.
Colin,
\nA 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.
