Results 1 to 1 of 1

Thread: update record when another is selected from lookup

  1. #1
    Join Date
    Apr 2009
    Location
    Sydney, Australia
    Posts
    110
    Thanks
    15
    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
    Code:
    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.

Bookmarks

Posting Permissions

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