How to calculate a total toll from multiple pipeline connecting to each other
Hello everyone, I am current building a database of all oil pipelines. My ultimate goal is that users are able to just put start pioint (usually City) and End point, then the database can return the total pipeline toll which is usually sum of multiple connecting pipelines that will bridge the start point and end point. I have created a simply database with most of pipeline information. The question I have now is how to create a mechnisim that allow user to perform such task? do I need to write script? Thanks Everyone.