How to update 2 tables from one form

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?

thanks,
Vinnie
damixaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

damixaAuthor Commented:
Also another question that came up. Do i need a third table with the relationship to adhere to 3NF principles, or can I instead just have a table that has NoteID, main_id (foreign key) and the note field) Would this be acceptable, doing away with the whole relationship table?
0
Jeffrey CoachmanMIS LiasonCommented:
You should only have to update this data once, ...and only in one table.
(You can pull this data into any other table with a query or a Lookup function)

tblMain
mID (PK)

tblNotes
nID (PK)
n_mID (Fk)

I don't see the need for that many-to-many table unless one main record can have many notes AND one note can have main main records.

JeffCoachman
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.