Hi,
I have a virtual table pulling from a SQL table with a "status" column with integers as a lookup value to another lookup table.
1= started
2= in process
3=pending, etc.
In the Canvas, app I would simply create a lookup function, and if the table was standard, I would make a lookup column. However, I am required to keep the SQL table due to other integrations. I would like to use a model driven app for the filtering and sorting ability. The problem is that the user just sees integers and not the lookup value in the table. I would like to see if it was possible to
a) show the lookup value
b) if the table is editable, could I filter the lookup table to the status item values in a dropdown for the user to select.
