<div>
create table relationship<br />
<br />
set the referntial integrity<br />
Cascade delete<br />
cascade update
</div>


create table relationship

set the referntial integrity
Cascade delete
cascade update

<div>
Yeah but the records arent exactly the same, one table has a couple of extra fields, will it still work?
</div>


Yeah but the records arent exactly the same, one table has a couple of extra fields, will it still work?

<div>
<div class="content wysiwyg-content">
I have a form which enters a customers address details in a table. It then asks if you would like to add the address into another table ( job address table).<br />
<br />
The problem I have is, is that these records can then be edited (individually). How can I make it so that if one of the addresses (multiple fields) is edited, it will automatically uupdate the same record in the other table?<br />
<br />
Thanks
</div>
</div>


I have a form which enters a customers address details in a table. It then asks if you would like to add the address into another table ( job address table).

The problem I have is, is that these records can then be edited (individually). How can I make it so that if one of the addresses (multiple fields) is edited, it will automatically uupdate the same record in the other table?

Thanks

Updating Records in multiple tables

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.