Results 1 to 2 of 2

Thread: Lookup fields in Queries

Threaded View

  1. 08-11-2003, 04:11 PM #1
    sroyalty
    sroyalty is offline Registered User
    Join Date
    Aug 2003
    Location
    Kentucky
    Posts
    1

    Question Lookup fields in Queries

    I have a lookup field in a table, and I'm trying to do a query. The query displays the record of the lookup field. How can I change the record to the name that is associated with that record.

    UserID is the Lookup Field

    UserID 34
    First Name John
    Last Name Doe

    Query

    display for record 34
    John Doe
    Last edited by sroyalty; 08-11-2003 at 04:16 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules