I need to create an inventory website for different system groups, I'm having difficulty with possible duplicate information for each table/group. I have 3 table I need to connect.Such as version #. I need to connect the hardware to a particular software which can also be used in another group.
GroupID Name Purpose contact Email Phone Number
SLAB System Test Jon Johl@IKNOW 612-245-1111
Elab Elab Dev. Phil Phi@UKNOW 475-124-1111
hardwareId group Asset Quantity Manufacturer Type Version
1 Elab xSeries 326 2 IBM Server 326
2 Slab BladeCenter 1 IBM Chassis H
3 Slab LS20 Blades 8 IBM Server L20
SoftwareID Group Assest Quantity Manufacturer Operat.System Version
Last edited by loquin; 07-18-06 at 12:14.
Reason: add [code] [/code] tags for readability.
It appears that you need to define a many-to-many relationship between the hardware and the software.
A many-to-many relationship is created by defining an intersection table.
For starters, I would suggest that you review the first two posts in this tutorial.
Last edited by loquin; 07-18-06 at 12:25.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert