<div>
You are welcome.<br />
<br />
Please ... with that setting I showed you ... be VERY careful - and be sure that you are updating exactly the fields you want - not for example, updating the One side of a one to Many relationship that has Cascade Updates enabled - etc.<br />
<br />
mx
</div>


<div>
Thanks for the further information. &nbsp;I will only be updating the many side of the relationship and I will be testing it for a time before it goes live. &nbsp;Thanks again.
</div>


<div>
<div class="content wysiwyg-content">
I have two tables. &nbsp;I have created a query creating a dataset with one field from Table A which is not updateable and several fields from Table B which I would like to update by entering data directly into the fields while I am viewing the dataset. &nbsp;Is there a way to do this?
</div>
</div>


I have two tables.  I have created a query creating a dataset with one field from Table A which is not updateable and several fields from Table B which I would like to update by entering data directly into the fields while I am viewing the dataset.  Is there a way to do this?

You are welcome.

Please ... with that setting I showed you ... be VERY careful - and be sure that you are updating exactly the fields you want - not for example, updating the One side of a one to Many relationship that has Cascade Updates enabled - etc.

mx

Thanks for the further information.  I will only be updating the many side of the relationship and I will be testing it for a time before it goes live.  Thanks again.

Update underlying table by changing data in query dataset

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.