Use Access to create a view with a query to create a lookup.
Select Query -> Create a query in the design view, then close the pop-up table selection dialog,
On the window below, right-click Select SQL view, of course, you can also enter the system menu or toolbar at this time;
The query result returns the query statement editing interface is also right to select the SQL view on this form.
However, remember that it is not necessary to save the results, or it is really a view.
