Results 1 to 6 of 6
  1. #1
    BawdyB is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    May 2013
    Posts
    3

    Query with Foreign Keys

    So I have a database for a catering company with menus and staff and orders (this is sort of relevant, I promise).
    I am trying to have a query that displays the name of the staff member needed to prepare each menu item. In the menu table, they are listed by staff number. My staff table has their staff number as PK and then all of their relevant information.
    When I construct a query with both tables (and I have set up a relationship between the staff# fields in each table), everything comes back blank.

    Thoughts?

  2. #2
    rzw0wr is offline I will always be a newbie
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Indiana
    Posts
    479
    I would like to see your tables.
    Hard to say what is wrong.

    Dalr

  3. #3
    BawdyB is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    May 2013
    Posts
    3

    Sure!

    TestDatabase1.accdb

    Here are the two tables in question

  4. #4
    rzw0wr is offline I will always be a newbie
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Indiana
    Posts
    479
    Took the format off of your Kitchen staff ID.

    TestDatabase1.zip


    If you need further help let us know.

    Dale

  5. #5
    BawdyB is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    May 2013
    Posts
    3
    That'll work. Thanks for the quick response!

  6. #6
    rzw0wr is offline I will always be a newbie
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Indiana
    Posts
    479
    My pleasure.

    Dale

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

Similar Threads

  1. ComboBox Filter with foreign keys?
    By Richie27 in forum Access
    Replies: 5
    Last Post: 05-30-2012, 09:40 AM
  2. primary/foreign keys
    By st1300 in forum Database Design
    Replies: 38
    Last Post: 12-04-2011, 01:27 PM
  3. Need help with foreign keys
    By acdougla17 in forum Access
    Replies: 1
    Last Post: 09-26-2011, 03:50 PM
  4. Foreign keys in a consolidated table
    By threepwoodjr in forum Database Design
    Replies: 3
    Last Post: 01-14-2011, 11:25 PM
  5. Primary/foreign keys + relationships
    By tripptofer in forum Database Design
    Replies: 0
    Last Post: 08-12-2009, 07:44 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