AnsweredAssumed Answered

Simple Relationship

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


Simple Relationship


     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.