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.