title: SQL 2000, Access Query
body: <p>I have a SQL database where one of my fields 'Status' has one of 10 entries in it (not from a dropdown list).  I let some people have access to the data through an Access database, they can add and modify entries.</p>
  
  <p>My question is, in Access, how can I make it so that the 'Status' field is a drop-down list from which the users can choose from (the 10 entries which are already in the SQL database)?  It would be easier for them and also mean that mistakes cannot be made.</p>
  
  <p>Many thanks</p>
  
  <p>Scott</p>