<div>
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?
</div>


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?

<div>
<div class="content wysiwyg-content">
Maybe this is an easy question but for some reason I'm struggling with it. <br />
<br />
I have the following tables<br />
<br />

<div class="bullet">
tbl_main with main_id primary key that holds the bulk of the information
</div>
<div class="bullet">
tbl_notes with primary key notes_id that holds just the notes
</div>
<div class="bullet">
tbl_main_notesrelationship<wbr /> that holds the foreign keys for both tbl_main and tbl_notes
</div>
<br />
So when I access a form that holds primarily the information on tbl_main I have a &quot;Add Note&quot; button. When I enter the note, it should update the tbl_notes and also tbl_main_notesrelationship<wbr /> that says that that specific note ID is associated to the tbl_main.id in a one-to-many relationship.<br />
<br />
Somehow I cant get my brain to update both of these tables at the same time. Am I overthinking it?<br />
<br />
thanks,<br />
Vinnie
</div>
</div>


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

How to update 2 tables from one form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.