I have a database with 3 main tables- I'll call them Table A, B & C for simplicity. A is 1 to Many to B, which is 1 to Many to C.
Each of the 3 tables has a Notes field which with a script that inserts Current Date and Username for the person entering a note into that field.
I am trying to structure a layout that will show ALL recent notes on 1 page- from all 3 layouts. I'm trying to do this from the context of Table A, since that is the highest level (parent) table. Not sure how to do this to show ALL notes, however across all records/all tables.
Any advice and how to go about this would be appreciated.