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. __________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php