sniperman
01-21-2011, 04:42 AM
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)
Account Details
____________________
* Domain Name Address (new data)
^ Account Holder (new data)
The * denotes a relationship between tables.
I have already created this
SELECT [Account Details].[Domain Name Address] FROM [Account Details] ORDER BY [Account Details].[Domain Name Address];
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.
Service Location Table
____________________
Service Location (new data)
* Domain Name Address (lookup)
^ Location Owner (auto update lookup)
Account Details
____________________
* Domain Name Address (new data)
^ Account Holder (new data)
The * denotes a relationship between tables.
I have already created this
SELECT [Account Details].[Domain Name Address] FROM [Account Details] ORDER BY [Account Details].[Domain Name Address];
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.