How to show the last ""note"" record in a report

Good point. I know that you folks are Cirrus ally try to avoid reverse relationships for performance reasons.

Any even better suggestion is to use an Action as that is less technical to setup. The trick though is to make the Report Link field which defines the record to be edited. It will need to be built on he child Notes table and edit the Parent.

So the report link field on the child will need to have the field [Related Parent] on the left and [Record ID#] of the Parent Table on the right.