Lookup from a table

[Sgte]

Our database is split between a front and back end - with the tables in the back end. Now I want to create a new table and the second field will be one to lookup a client's unique code. However there are three types of client and they are drawn together in a SQL query. Obviously this query is stored outside of the back end, so can I access it to use as a lookup field in the new back end table?

[HansV]

You don't really need a lookup field in the table - you can do the lookup in the frontend.