hello again,
i need to create a pathway of all my Low_voltage_Cables that connect to each Power_Pole, feed from a Substation with numerous LV_Feeders.
it is not a linear pathway. The LV cables often fork and join off in different directions - i refer to this as pole pathway branching.
Each pole thou, feeds back to a Source Sub Station - through 1 of 3 (or more) LV Feeders.
i figure i can use 4 tbls which are related. (From Power source to household)
Sub_TBL, LV_Cable_TBL, Pole_TBL, CustomerID.
Low_Voltage_cables_tbl fields
LV_cable_ID, Segment_from_to, Segment_From, segment_To, LV-Feeder, source_sub
1, poleID1-poleID2, poleID1, PoleID2, A, sub1
2, poleID1-PoleID3, poleID1, poleID3, A, Sub1
3, poleID2-poleID4, poleID2, poleID4, A, Sub1
4, poleID1-PoleID5, PoleID1, PoleID5, B, Sub1
6, PoleID1-PoleID6, PoleID1, PoleID6, C, Sub1
Power_Pole_Tbl Table fields
PowerPoleID, pole_name, Source_Sub, LV_Feeder
1, poleID1, sub1, A
2, poleID2, sub1, A
3, poleID3, sub1, A
4, poleID4, sub1, A
5, poleID5, Sub1, B
6, PoleID6, Sub1, c
Sub_Tbl
SubID, Sub_Name, LV-Feeder1, Lv_feeder2, LV_feeder3,
1, sub1, A, B, C
2, Sub2, A, B, C
CustomerID Table Fields
CustomerID, Conn_Num, Feed_from_Pole, Feed_from Feeder, Feed_from_sub
1, 1000, PoleID1, A, Sub1
2, 1005, PoleID3, A, Sub1
3, 1002, PoleID2, A, Sub1
4, 1008, PoleID5, B, Sub1
5, 1180, PoleID6, C, Sub1
What i would like to do is create a pathway from PowerSource down to customer.
So when i enter a Fault (in another Table), say LV_cable_ID 1 is cut.
that i can show in a query all the Customers, Poles and LV_cables connected on LV_FeederA affected from loss of power to LV_cable_ID1.
Can someone please help guide me on how to use Access to create this directional pathway for me, so i can show and outage on affected Assets (LV_cable, Pole, customer_ID) from a Cut LV_Cable.
I have actually created a query that shows All Customers on Sub1, LV-feeder A.
But i cannot think how to show the cut in LV_Cable (which links from Sub To Pole to pole... to customer)
so only the customers beyond the cut LV_Cable are displayed.
I think I need to do a 2 step query?? is that correct??
please help.
thanks in advance
BTW some poles have no customers connected.