user2680039 user2680039 - 17 days ago 6
SQL Question

Limit a table's cell's values to two values?

I have a two-column table but I want all values in the first table to be either X or Y, and no other input should be allowed. How can I enforce this?

Answer

You can use a validation rule.

Restrict data input by using a validation rule

A Validation Rule on the column as follows will work.

="X" Or ="Y"