Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Sep 2002
    Location
    Pendleton, Indiana, USA
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Getting Info from different Tables (2000)

    I was ondering the easiest way to do the following: I have multiple tables that hold various equipment info. Everything is tied to a phone extension(not primary key). One table has the persons name that resides @ that ext. When I run queries for reports on say computers I would like it to display the name of that person along with some other info. I hope that makes sense. Thanks for any help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Getting Info from different Tables (2000)

    You can add the phone/person table to the query (for example for computers). Join the tables on phone extension, then double click the join and select the option to return all records from the computers (or whatever) table.Add the person's name to the query grid.
    If the phone extension is not the primary key in the phone/person table, the query I describe here will not be updateable. For a report, that shouldn't be a problem.

Posting Permissions

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