Hi, I am working on a program for a clothing manufacture and need some help designing the tables for the database. I have to track the inventory levels of each style by color and size and can not figure the tables out. Here is the information I need to track. Style number Color Size (can have from 1 to 10 different sizes) Also need to track the transactions. Receipt Number for incoming inventory and Invoice number for outgoing. Can anyone help me figure out how to setup the tables? Once that is done, I think I can get the rest working. Thanks!!! Kevin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php