Hello; Is there some way to create a collumn, where the only possible values are enumerated in other table? I'm looking for something like this: ENUM("SELECT xy FROM tab;") I'm able to do it with perl+CGI. But is there some easier way? Maybe it's a stupid or already discused question, but I haven't found anything about it. Malmo ---------------------------------------------------- Malmo> If I only got 20$ for evryone who's too lazy to configure his own comp. Bill Gates> "Why not?" --------------------------------------------------------------------- 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