Blue
White
Purple
Green
Red
Orange
Blue Light
White Light
Purple Light
Green Light
Red Light
Orange Light
Hi, using lookup table with the "WHERE" clause works great for edit/add, but as soon as you put in the WHERE the list page no longer uses the lookup but reverts to plain text?
Hi,if you want to use where clause on the LIST page add this clause on the EditSQL query tab.