AnsweredAssumed Answered

Simple Relationship

Question asked by Christian on Sep 18, 2012
Latest reply on Sep 19, 2012 by philmodjunk

Title

Simple Relationship

Post

     Hi Everyone,

      

     I have been working with this for a while now, but can't seem to figure out what I'm not doing right...

      

     I have a personnel database for a college within a university.  The college operates on multiple campuses.  I would like to link the faculty member to which campus he or she works.  Simple.

     I have a separate personnel and company database, and created a one-to-many relationship between the two.

     On my personnel layout, I have a drop-down box where users select on which campus each faculty member works.

      

     For some reason, however, this relationship does not work.  I have two companies currently set up, but when I select for one faculty to be on a certain campus, it overwrites the other company record.  They just don't seem to play well together.  I've attached a screen shot of my relathipships.

      

Screen_shot_2012-09-18_at_1.56.37_PM.png

Outcomes