For MySQL databases, is there any ability (or method) to construct 'record layouts' which would provide alternate fields within the record ? I'd like to create a "codes" table, where different types of reference 'codes' would be stored (i.e. "payment terms", "tax authorities", "credit card types", etc). Though the primary fields would be the same (i.e. 'code type', 'code', 'description', 'active/inactive flag') there'd be fields specific to the type of code being stored in the table (i.e. 'days to pay', 'tax percentage', 'withholding percent', etc). I don't want to create a large number of tables to contain each 'type' of code. I'm using PHP, which might have a solution (such as storing the 'specific' data as a single text array within the record, and parsing it after it's read from the table). --------------------------------------------------------------------- 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
