1 message in com.mysql.lists.mysqllook-up fields in MySql
FromSent OnAttachments
Shekar A. Rodriguez02 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.