title: Can a Sharepoint Web Database Lookup Field use a query?
body: <p>I'm working with this table and want to offer the user a Lookup list in one column. I can do this easy if I want to use a whole table.</p>
  
  <p>But I want to show in this lookup just a subset of data.</p>
  
  <p>Like this: <code>SELECT ID, Name FROM Items WHERE Type = 'SomeType'</code></p>
  
  <p>I have a query, but when I go into Lookup Wizard, I cannot select Queries. Why is this?</p>
  
  <p>This is Sharepoint 2010, editing the Web Database in Access.</p>