Results 1 to 1 of 1

Thread: update record when another is selected from lookup

  1. #1
    Join Date
    Apr 2009
    Sydney, Australia
    Thanked 1 Time in 1 Post

    Default 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)

    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.
    Last edited by sniperman; 01-21-2011 at 11:48 AM.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts