Results 1 to 2 of 2
  1. #1
    dcurtis is offline Novice
    Windows 7 Access 2007
    Join Date
    May 2010
    Posts
    1

    Question Linking tables conditionally

    I am very new to Access and am doing my best not to sound too stupid. I have been working with it for 2 days and not doing too bad at it for that amount of time.
    I downloaded some templates from MS and have studied them but can't figure out how too accomplish what I need.

    I am attempting to build a PC inventory database for our company and have several tables setup as follows...

    Computer Info.
    Fields = Mfg | Type | Model
    Computer MFG
    Fields = Dell | Gateway
    Computer Type
    Fields = Desktop | Laptop
    Dell Desktops
    Fields = "Dell Desktops" with all models we purchase listed
    Dell Laptops
    Fields = "Dell Laptops" with all models we purchase listed
    Gateway Desktops
    Fields = "Gateway Desktops" with all models we purchase listed
    Gateway Laptops
    Fields = "Gateway Laptops" with all models we purchase listed

    Computer Info. is my main table that the other tables will be linking into. But, here is where I am getting confused.

    Example" When I choose "MFG" Dell and "TYPE" Laptop I only want it to show choices from the "Dell Laptops" table.
    Example" When I choose "MFG" Dell and "TYPE" Desktop I only want it to show choices from the "Dell Desktops" table.
    Example" When I choose "MFG" Gateway and "TYPE" Laptop I only want it to show choices from the "Gateway Laptops" table.
    Example" When I choose "MFG" Gateway and "TYPE" Desktop I only want it to show choices from the "Gateway Desktops" table.

    All Key Fields in all tables are "Auto Number"


    Let me know if this doesn't make sense or if you need more information.

    I would appreciate all advice and help you can give me.

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    This only needs one table.
    tblPCInventory:
    ComputerID
    CompMFG
    CompType
    CompModel

    You just enter all the info there and then query for what you want. you dont need to search multiple tables for the criteria you want. Lets take your first example:
    Example" When I choose "MFG" Dell and "TYPE" Laptop I only want it to show choices from the "Dell Laptops" table.
    query for that would be:
    SELECT *
    FROM tblPCInventory
    WHERE CompMFG = "Dell" AND CompType = "Laptop"

    This will now provide you with all records that are Dell Laptops.

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

Similar Threads

  1. Linking tables / Queries
    By mulefeathers in forum Queries
    Replies: 7
    Last Post: 04-21-2010, 02:10 PM
  2. Linking Tables
    By Richard Hale in forum Access
    Replies: 0
    Last Post: 01-25-2010, 02:09 PM
  3. Linking two tables
    By nitsua0491 in forum Forms
    Replies: 2
    Last Post: 10-02-2009, 07:48 AM
  4. Replies: 0
    Last Post: 03-08-2009, 05:12 PM
  5. Linking Tables?
    By briancb2004 in forum Access
    Replies: 0
    Last Post: 09-29-2008, 01:14 PM

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