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.