Relationships Between Nodes on Field I'm trying to work with some information out of our enterprise system to create an employee directory, and I have a question regarding how I can relate nodes together.

I have a content type called Employees, and it has a number of fields, including Employee ID, First Name, Last Name, etc.

I then have a content type called Positions, and it has a number of fields, including Employee ID, Title, etc. 

I'm trying to figure out how I can link the Positions and Employee nodes together on the Employee ID field rather than the nid. 

Any help would be appreciated. Thanks!
If you're looking for a relatively simple option, Entity Reference is probably best:


  Provides a field type that can reference arbitrary entities:
  
  A generic entity reference field Four widgets: Two implemented on top
  of the Options module (Select and Radios/Checkboxes), Two autocomplete
  widgets (one with one text field per entry, one tag-style with
  comma-separated entries in the same text field) Two formatters: A
  "Label" formatter, with optional link that displays the label of the
  referenced entity (the node title, the user name, etc.) A "Rendered
  entity" formatter, that renders the references entity using a
  configurable view mode Integration with Views (for both forward and
  backward references) Integration with Entity Metadata (and as a
  consequence with Search API and the like) Integration with Devel
  generate Integration with Feeds and Migrate (>= 2.3) for painless data
  import


EDIT #1

To set up the view as described in comments:


Create the view for Employee Content Type, and make settings how you desire
Add a Relationship to Entity Reference: Referenced Entity for the entity reference field, Require this relationship


Now you have access to the fields in the referenced (position) content type and can display them in your view.  One thing of note, Title field may not work from Position, so you may have to include a separate field for the Position Title. Otherwise, everything should work as a normal view