update record when another is selected from lookup
I have a database which has two tables for "Account Details" and "Service Location".
Service Location Table
Service Location (new data)
* Domain Name Address (lookup)
^ Location Owner (auto update lookup)
* Domain Name Address (new data)
^ Account Holder (new data)
The * denotes a relationship between tables.
I have already created this
To avoid manual data entry I would like to create a query for the Location Owner field in Service Location Table to auto update based on the query above.
SELECT [Account Details].[Domain Name Address] FROM [Account Details] ORDER BY [Account Details].[Domain Name Address];