Hi All,
I am trying to create relationships between tables on demand. Meaning, user selected. I have been charged with building an Inventory Database for our network circuits (ie OC48,DS3,DS1,DS0). Under normal circumstances you couldnt have a DS3 without an OC level circuit. But at our company we do have inventory that does not have a higher level circuit.
I was going to build a table for each level.
tblOC48
tblDS3
tbDS1 etc...
Then when the user goes to enter new inventory, they open the appropriate form attached to that table and add the circuit being installed, while in the back ground the system auto links to the next table down.
So for example, our provisioners order a DS3. And also order the associated DS1's for that DS3. So they need to add the 28 T1's that go with it. So instead of going to the highest level (OC48) and entering all the way down through to the DS1 level, I would like there to be no relationships until the actual circuit level is selected and then have the system auto create the relationship to the needed table. In this case, from the tblDs3 to tblDS1.
Hope this makes sense and is possible. Or is there a better way to accomplish this task. Keep in mind there will also be situations where we start at the OC48 level and then Slot 48 DS3s to that OC48, and then slot the DS1's to each DS3.
Thanks everyone,.
I am trying to create relationships between tables on demand. Meaning, user selected. I have been charged with building an Inventory Database for our network circuits (ie OC48,DS3,DS1,DS0). Under normal circumstances you couldnt have a DS3 without an OC level circuit. But at our company we do have inventory that does not have a higher level circuit.
I was going to build a table for each level.
tblOC48
tblDS3
tbDS1 etc...
Then when the user goes to enter new inventory, they open the appropriate form attached to that table and add the circuit being installed, while in the back ground the system auto links to the next table down.
So for example, our provisioners order a DS3. And also order the associated DS1's for that DS3. So they need to add the 28 T1's that go with it. So instead of going to the highest level (OC48) and entering all the way down through to the DS1 level, I would like there to be no relationships until the actual circuit level is selected and then have the system auto create the relationship to the needed table. In this case, from the tblDs3 to tblDS1.
Hope this makes sense and is possible. Or is there a better way to accomplish this task. Keep in mind there will also be situations where we start at the OC48 level and then Slot 48 DS3s to that OC48, and then slot the DS1's to each DS3.
Thanks everyone,.