Something along these lines should get you started Tclothes (holds all the possible variations of size, colour and style) Id PK Styleid FK to Tstyle Sizeid FK to Tsize Colourid FK to Tcolour Tstyle Styleid PK StyleDescription VARCHAR Tsize Sizeid PK SizeDescription VARCHAR Tcolour Colourid PK ColourDescription VARCHAR Mark -----Original Message----- From: kevin@xxxxxxxxxxxxxxxxxx [mailto:kevin@xxxxxxxxxxxxxxxxxx] Sent: 20 May 2005 00:12 To: php-general@xxxxxxxxxxxxx Subject: OT - Table help needed~ PLEASE 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 Gamma Global : Suppliers of HPCompaq, IBM, Acer, EPI, APC, Cyclades, D-Link, Cisco, Sun Microsystems, 3Com GAMMA GLOBAL (UK) LTD IS A RECOGNISED 'INVESTOR IN PEOPLE' AND AN 'ISO 9001 2000' REGISTERED COMPANY ********************************************************************** CONFIDENTIALITY NOTICE: This Email is confidential and may also be privileged. If you are not the intended recipient, please notify the sender IMMEDIATELY; you should not copy the email or use it for any purpose or disclose its contents to any other person. GENERAL STATEMENT: Any statements made, or intentions expressed in this communication may not necessarily reflect the view of Gamma Global (UK) Ltd. Be advised that no content herein may be held binding upon Gamma Global (UK) Ltd or any associated company unless confirmed by the issuance of a formal contractual document or Purchase Order, subject to our Terms and Conditions available from http://www.gammaglobal.com E&OE ********************************************************************** ********************************************************************** -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
