Well i was able to figure it out. in case anyone chanced upon this search and finds a simlar situation this is how
i went about it. Using Graphs Representation and BFS & DFS for path or route finding
- i represented each conn.# or connector.# as a vertices or a node
- created an undirected edge as a link or a connection to another conn.# object
- created a graph out of the table
- Used BFS,DFS to find the paths or route.