🚀 go-pugleaf

I'm struggling with trying to set up a fairly simple lookup routine
between a master file and a small table file.  My LIBRARY has a 'code'
which should cross reference with a TABLE file containing the code plus
a description.  I want to use a combobox to display the description,
select the description I want, then replace the LIBRARY code field with
the TABLE code corresponding with the description.

In VdB5 I used the LOOKUP() function.  I gather that instead of this
function in VdB7 I should be able to use the lookupSQL.  But after
studying and experimenting with the documentation and example in the
help file language reference, I'm stumped.

I'm using the following code in the Combobox ONCHANGE event:
        select desc, type FROM typetbl
but I get a database engine error: Invalid use of keyword desc,

I'm obviously missing something pretty simple but I can't seem to pin it
down.  Any help will be appreciated.

Thanks
Carl