I have a 1-Many relationship set up, with a master table and a Notes table to allow me to record multiple sets of notes against my master table record.
Master Table: Notes Table
Design Meeting Aug Note 1, Created On, Created By
Note 2 . etc
Design Meeting Sept
Planning Meeting Aug
I want to be able to record multiple Notes against an entry on my master table, but I want to drive this from my master table which has lots of entries and some useful views to help users navigate. To initiate this from the Notes table would be cumbersome. Is there a way to create this “sub-record” in my NOTES table directly from the selected Master record?