I have two tables, a project record table and a notes table. The notes table has a table to table relationship to the project record table. What I'm attempting to accomplish is to have a field in the project record table which captures the last note in the note table associated with that project. That way when I run reports I don't have to rely on only showing a link to the notes. I can actually show the last note in the report. I hope this makes sense what I'm trying to accomplish. I'd love any thoughts/recommendations from the community.
Personally I like to just use the IOL technique and then use API_DoQuery otherwise I would have a ton of many-to-many relationships by now. Good luck! Can also implement it within an hour and screenshare the process if you want as well.
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.