I am using Access 97.
Anyone have any idea how to properly set up my table relationships for the following data:
There are two main entries:
Type Name System Location IP address
OPC primary: 0100P AA48 1.2.3 11.22.3
OPC backup: 0100B BC48 1.2.4 7.8.22
Then, for that set above, there are 24 sub entries:
NE NE# Building ID Type Comments
1 100 BAL BB48 LTE
2 119 ZBB RE LTE
3 113 AW DD LTE
...
24 231 BD GR LTE
There will always be a primary and a backup and they will always be named xxxxP and xxxxB.
The 24 entries related to the primary and the backup above are related to both entries. In other words, it is NOT like the first record relates to the primary and the second relates to the backup. You have a primary and a backup OPC and it contains ALL 24 entries.
Any ideas how to establish my relationships?
Thanks,
Ruth
[sig][/sig]
Anyone have any idea how to properly set up my table relationships for the following data:
There are two main entries:
Type Name System Location IP address
OPC primary: 0100P AA48 1.2.3 11.22.3
OPC backup: 0100B BC48 1.2.4 7.8.22
Then, for that set above, there are 24 sub entries:
NE NE# Building ID Type Comments
1 100 BAL BB48 LTE
2 119 ZBB RE LTE
3 113 AW DD LTE
...
24 231 BD GR LTE
There will always be a primary and a backup and they will always be named xxxxP and xxxxB.
The 24 entries related to the primary and the backup above are related to both entries. In other words, it is NOT like the first record relates to the primary and the second relates to the backup. You have a primary and a backup OPC and it contains ALL 24 entries.
Any ideas how to establish my relationships?
Thanks,
Ruth
[sig][/sig]