<div>
I have been deleting fields that the relationship was built on, so it makes sense that I am prompted to remove the relationship first.<br />
<br />
Are there any other methods to effectively modifying the data without breaking the relationship?<br />
<br />
Thanks
</div>


I have been deleting fields that the relationship was built on, so it makes sense that I am prompted to remove the relationship first.

Are there any other methods to effectively modifying the data without breaking the relationship?

Thanks

<div>
You mean modifying the design of the tables and relationships? I don't see why you would regularly want to modify this. Your database architecture should not change one you're complete with design. Maybe if you provide some examples I can give more specifics...
</div>


You mean modifying the design of the tables and relationships? I don't see why you would regularly want to modify this. Your database architecture should not change one you're complete with design. Maybe if you provide some examples I can give more specifics...

<div>
<div class="content wysiwyg-content">
In updating Access tables, I often am required to break relationships before a table can be updated (i.e. adding/deleting or formatting fields). <br />
<br />
This has not been a problem thus far, but as the database grows in complexity I am gathering suggestions on how other Experts manage updating tables when there are numerous relationships embedded.<br />
<br />
Thanks. 
</div>
</div>


In updating Access tables, I often am required to break relationships before a table can be updated (i.e. adding/deleting or formatting fields). 

This has not been a problem thus far, but as the database grows in complexity I am gathering suggestions on how other Experts manage updating tables when there are numerous relationships embedded.

Thanks. 

Access Update Tables with Relationships

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

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.