Blue
White
Purple
Green
Red
Orange
Blue Light
White Light
Purple Light
Green Light
Red Light
Orange Light
I need to validate a field (numeric) with data belonging to another table, this is sql server.
Not sure how exactly you want to validate this field but you can do this in BeforeAdd/BeforeEdit events.