title: Autonumber vs. Text String for primary key?
body: <p>I'm trying to find the best solution to an issue I've just come across. I hate doing things without understanding so I'm hoping someone can help.</p>
  
  <p>I have an Access database with a table that stores Hotel Information - and then another table that stores Itineraries. The Itineraries table will select from the list of Hotels on the Hotels table.</p>
  
  <p>I want to make a proper relationship, but using an Autonumber primary key on the Hotels table that connects to the Hotels field on the Itineraries table won't work. (because the Autonumber ID doesn't match the hotel names.)</p>
  
  <p>Is it better to:</p>
  
  <p>A. Use the Hotel name as the primary key on the hotels table, even though the string length may get pretty long?</p>
  
  <p>B. Change the display control on the Hotels field on the Itineraries table to a combobox that lists the Hotels table autonumber primary key - but hides it. Instead it shows the column with the hotel names. I found that solution here: <a href="http://www.trigonblue.com/accesslookup.htm" rel="nofollow">http://www.trigonblue.com/accesslookup.htm</a></p>
  
  <p>Neither solution seems perfect as I think solution A may slow the indexing down with long text strings, and solution B gets messed up if new fields are inserted in the table.</p>
  
  <p>I'd hate to pick the wrong answer here and have problems down the road.</p>
  
  <p>Can anyone help me out here? Please let me know if I need to clarify any part of my question.</p>
  
  <p>Thanks!</p>