Use Inner Join
Can I use Inner join query (1 column from current table and another column from another table)?
Solution:
For simple 'lookup' table, you can use
https://phpgrid.com/documentation/set_col_edittype/
Set the type to '
select
'.select
'.