Hello,

I am busy designing a number of tables and for some fields I want to limit the allowed values. For example

field: currencies: allowed values: GP, EUR, RUP, USD
gender: allowed values: M, F

In doing so entering FL or DEM in the field currency will not be accepted
C in the field gender will not be accepted

What to do.

Many thanks in advance

John

You could put these values into drop-downs or radio buttons is one way to handle this but I think the best way is to create a Currencies table with an identity column, put the values into a drop-down and save the identity value in the parent table.

For male and female you could use a bit column.

Lookup "constraints, CHECK" in Books Online.

__________________
--Jeff Moden

Thanks for your help!

Kind regards,

John