Restricting values according to another table
Hello.
I was wondering if it is possible in MySQL to restrict the values you can enter into a field, according to the contents of another table. I know you can use ENUM('value', 'value', 'value') to do this normally, but I would like to make it look at the values in a column in a different table to determine what those acceptable values are. Is this possible?
Thanks in advance,
--
Dave.
I was wondering if it is possible in MySQL to restrict the values you can enter into a field, according to the contents of another table. I know you can use ENUM('value', 'value', 'value') to do this normally, but I would like to make it look at the values in a column in a different table to determine what those acceptable values are. Is this possible?
Thanks in advance,
--
Dave.
Restricting values according to another table