R
Rachel Garrett
Greetings,
Suppose I have a database with a category for Region, and the
possibilities are North, South, East, and West. (I might want to add
regions in the future, and some tables will have more than one record
per region, so Region needs to be its own column rather than having
columns for North, South, East, and West individually.)
Now let's say that there are some tables that use Region, where I want
to allow only one record for North, one record for South, one for
East, and one for West.
What is the best way to accomplish this?
Thanks,
Rachel
Suppose I have a database with a category for Region, and the
possibilities are North, South, East, and West. (I might want to add
regions in the future, and some tables will have more than one record
per region, so Region needs to be its own column rather than having
columns for North, South, East, and West individually.)
Now let's say that there are some tables that use Region, where I want
to allow only one record for North, one record for South, one for
East, and one for West.
What is the best way to accomplish this?
Thanks,
Rachel