That was the road I was thinking, just needed a reality check.Understand all on the naming convention; just wanted to make the example as simple as possible.Math Works Machine Translation The automated translation of this page is provided by a general purpose third party translator tool.Math Works does not warrant, and disclaims all liability for, the accuracy, suitability, or fitness for purpose of the translation. The largest issue I am having; what is the best way to grab and modify the data in both tables.You also need to take a look at: Database Normalisation And Table Structures Thanks TSC! City_ID = (select City_ID from City where City Name = 'Melbourne') AND A. In your case we have and Access generates the following SQL (which I've indented for clarity) SELECT Instance.
As a best practice, there are two main steps that you must follow to create and run an update query: create a select query that identifies the records that you want to update, and then convert that query to an update query that you can run to update the records.
When the Show Table window appears, select the tables that you wish to use in the query and click on the Add button.
You can select multiple tables by holding down the Update Query from the popup menu.
To add new records to a database you use an append query, and to delete whole records from a database you use a delete query.
Note: You cannot run an update query in a Web browser.