title: How can I associate one record with another in the same table?
body: <p>I have created a cable database in Access, and I generate a report that has lists the connectors on each end of a cable.  Each cable has its own ID, and 2 connector IDs, associated with it.  All the connectors are from the same table and is linked to many other tables.  </p>
  
  <p>I need 2 fields in one table (cable) associated with 2 records in the second table.  </p>
  
  <p>My solution was to create 2 more tables: A primary connector table and secondary connector table, each of which has all entries from the first connector table.  Then I could create columns in the cable ID Table for the primary and secondary IDs.  The problem with this is that I have to maintain 2 extra tables with the same data.  </p>
  
  <p>I'm new to database theory, but I was wondering is there some advanced method that addresses this problem?</p>
  
  <p>Any Help would be appreciated!</p>