Maybe this is an easy question but for some reason I'm struggling with it.
I have the following tables
tbl_main with main_id primary key that holds the bulk of the information
tbl_notes with primary key notes_id that holds just the notes
tbl_main_notesrelationship that holds the foreign keys for both tbl_main and tbl_notes
So when I access a form that holds primarily the information on tbl_main I have a "Add Note" button. When I enter the note, it should update the tbl_notes and also tbl_main_notesrelationship
that says that that specific note ID is associated to the tbl_main.id in a one-to-many relationship.
Somehow I cant get my brain to update both of these tables at the same time. Am I overthinking it?