Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Table Relationships

Status
Not open for further replies.

midnightswan

Programmer
Nov 11, 2002
7
AU
Hi :eek:)
I was just wondering if I could have a multi-table one-to-one sparse dependent relationship between conceptional tables.
So there will be a base table with a fixed number of rows that contains the index. Then various other tables which uses the base table's index but may only contain a couple of rows that have specific attribute values for the indices of the base table. For example a device may have 10 slots, 3 with ethernet interfaces and 2 with serial interfaces and the other slots blank. The MIB design would be to have a base table with an index of the slot values 1-10, and then ethernet interface and serial interface tables that use the base table index. Is it possible to have this? and will it work?

Thanking you,
Hanh Thao Nguyen
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top