Results 1 to 4 of 4
  1. #1
    Denlkap is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2017
    Location
    Maryland
    Posts
    8

    Help with lookup tables

    I’m trying to develop an Access database. Among other things it contains account numbers and company names. Each account is unique to a company and the company can have more than one account. I have a table that contains each account and its associated company. I have a form to input information but I want to input just the account, not the company name, saves time. When I run a report I want to include the company with its associated accounts. How do I link the accounts with the company? Through a lookup table in a query? How is it done? Thank you all for your help.

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Among other fields, your tables should have the following fields (or something similar):

    Company Table
    CompanyID -primary key (unique)
    CompanyName
    ...

    Account Table
    AccountID - primary key (unique)
    CompanyID - foreign key (indexed)
    ...

    So then in your query, you should be able to join these two tables on the CompanyID field. You can then display any of the fields from either table in your query.
    Then if you use the query as the Data Source of your Report, you can include any/all of these fields.

  3. #3
    Denlkap is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2017
    Location
    Maryland
    Posts
    8
    Thank you. I’m a little slow at this but I think I finally understand it. It seems to be working but I need to play with it a little bit more. Thank you again.

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

Please reply to this thread with any new information or opinions.

Similar Threads

  1. D lookup between two tables
    By punna111 in forum Access
    Replies: 5
    Last Post: 03-26-2015, 09:19 AM
  2. Use of Lookup Tables
    By Saint in forum Access
    Replies: 1
    Last Post: 03-05-2012, 11:49 PM
  3. lookup tables
    By nkuebelbeck in forum Forms
    Replies: 3
    Last Post: 03-15-2010, 02:10 PM
  4. Lookup Tables
    By corinthianw in forum Access
    Replies: 1
    Last Post: 02-17-2010, 01:31 PM
  5. Lookup Tables
    By JoeBio in forum Database Design
    Replies: 1
    Last Post: 09-01-2006, 07:34 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
  •  
Other Forums: Microsoft Office Forums