Results 1 to 4 of 4
  1. #1
    fuecheefang is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2015
    Posts
    43

    Relationship Issues Help

    Im having issues with my new Projects that I add into the table with an owner, and its not updating the Resource table with the new projects that I add. Help, with laymens terms, still a rookie. Click image for larger version. 

Name:	relationship.PNG 
Views:	14 
Size:	33.7 KB 
ID:	22313

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,746
    In 6 lines or less of plain English, what is the business? And associated rules.

  3. #3
    fuecheefang is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2015
    Posts
    43
    Quote Originally Posted by orange View Post
    In 6 lines or less of plain English, what is the business? And associated rules.
    Project management DB, adding new projects is working ok, but its not showing up in my allocated resources tables even after inputting Owners in Projects table.

  4. #4
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    I doubt that the Employee ID should link direct to the Project Code.

    It looks like Resource is the child/many table to parent/1 Project table. Link those.

    Employees then is a child to Resource - presuming the accommodation of multiple Employees is a good thing

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

Similar Threads

  1. Relationship Issues
    By MTSPEER in forum Access
    Replies: 6
    Last Post: 06-05-2013, 01:01 PM
  2. Relationship Issues?
    By RatBronco in forum Access
    Replies: 3
    Last Post: 12-30-2012, 01:58 PM
  3. Form Design / Relationship Issues
    By brharrii in forum Forms
    Replies: 5
    Last Post: 06-23-2012, 11:37 PM
  4. Query issues due to a bad relationship!
    By annemrosenberg in forum Queries
    Replies: 18
    Last Post: 09-12-2011, 01:50 PM
  5. Relationship issues
    By asweisman in forum Database Design
    Replies: 1
    Last Post: 04-20-2009, 08:04 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