look-up fields in MySql - Shekar A. Rodriguez - com.mysql.lists.mysql

1 message in com.mysql.lists.mysqllook-up fields in MySql

From	Sent On	Attachments
Shekar A. Rodriguez	02 Mar 2001 14:29

Subject:	look-up fields in MySql
From:	Shekar A. Rodriguez (xshe...@yahoo.com)
Date:	03/02/2001 02:29:40 PM
List:	com.mysql.lists.mysql

I am creating a couple of tables. Some of the tables call for a column denoting the entry's type or catagories. The ENUM and SET types seems to be ideal for this except for the fact that I wasn't able to add types or categories dynamicly. Is there anyway that the ENUM or SET types could be used to list the set of values of a column in another table? (like lookup field in MS Access) Or if anyone has an alternative for implementing the system i describe I would be happy to hear about it.