>
i have a Database called Betatest in MySQL
i have three tables : Projects
ProjBom
Inventory
i wanna enter into projects the project name and date and later on i
wanna be able to add the Projectbom("bill of materials") for that
project, the ProjectBom is pulling
information from the inventory and Associating the ID's to the
projects the hopes is to See Total Costs Of each project but my issue is
how to associate all these together
For detailed Lists, can Someone Guide me into a starting point or
Help me thru this ,, thanks alot
My tables are Here for u to use as well
Projects defined as
--
-- Table structure for table `projects`
--
CREATE TABLE `projects` (
`id` tinyint(12) NOT NULL AUTO_INCREMENT,
`Projid` tinyint(12) NOT NULL,
`Projectname` varchar(24) NOT NULL,
`StartDate` date NOT NULL,
`BidCost` int(12) NOT NULL,
`Projcost` tinyint(8) DEFAULT NULL,
PRIMARY KEY (`Projid`),
KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Table structure for table `projbom`
--
CREATE TABLE `projbom` (
`id` tinyint(5) NOT NULL,
`Projid` tinyint(5) NOT NULL,
`Partnum` varchar(12) NOT NULL,
`Partdesc` varchar(34) NOT NULL,
`Qty` tinyint(12) NOT NULL,
`Cost` tinyint(12) NOT NULL,
PRIMARY KEY (`id`),
KEY `Projid` (`Projid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Table structure for table `inventory`
--
CREATE TABLE `inventory` (
`CategoryID` int(10) NOT NULL AUTO_INCREMENT,
`Manufacture` varchar(50) DEFAULT NULL,
`Catagory` varchar(255) DEFAULT NULL,
`ManuFacNum` varchar(50) DEFAULT NULL,
`NewUsed` varchar(50) DEFAULT NULL,
`Location` varchar(50) DEFAULT NULL,
`Qty` int(10) DEFAULT NULL,
`BinNumber` varchar(50) DEFAULT NULL,
`Cost` decimal(19,4) DEFAULT NULL,
`SellingPrice` decimal(19,4) DEFAULT NULL,
`PartsDescription` longtext,
`percentofMarkup` int(10) DEFAULT NULL,
`StockValue` int(10) DEFAULT NULL,
`Reorderlevel` int(10) DEFAULT NULL,
`Supplier` varchar(50) DEFAULT NULL,
PRIMARY KEY (`CategoryID`),
KEY `ProductName` (`Manufacture`),
KEY `SerialNumber` (`ManuFacNum`)
) ENGINE=MyISAM AUTO_INCREMENT=3337 DEFAULT CHARSET=latin1
AUTO_INCREMENT=3337 ;
--
-- Dumping data for table `inventory`
--
INSERT INTO `inventory` VALUES (31, 'ALLEN BRADLEY', 'Control',
'1746-A4', 'Used', 'Office', 1, 'B Top', 170.8800, 0.0000, '4 Slot Rack
for SLC500', 0, 0, 0, 'VMI');
INSERT INTO `inventory` VALUES (32, 'ALLEN BRADLEY', 'Control',
'1746-A7', 'Used', 'Office', 1, 'B Top', 252.3500, 0.0000, '7 Slot Rack
for SLC500', 0, 0, 0, 'VMI');
INSERT INTO `inventory` VALUES (36, 'ALLEN BRADLEY', 'Control',
'1746-A13', 'Used', 'Office', 1, 'B Top', 509.0300, 0.0000, '13 Slot
Rack for SLC500', 0, 0, 0, 'VMI');
[Non-text portions of this message have been removed]
