Connect the travel path in succession

[myousuff81]

I have a situation where in I need to arrange the data in order, for example a customer boards the bus from Station A to Station B called route 1, then he goes from station B to Station C and so on, however the data we have is not in sequence. 

We need to find routes that are in succession. To identify the succession the customer recognized that the station he departs to in the previous route was the arriving station in his current route.

Example:-

(1) Customer starts from his home and depart from bus station A (route 1)

(2) Arrives in station A and Departs to station B (route 2)

(3) Arrives in station B and Departs to Station C (route 3)

[handa997]

.

[uncle_whispers]

I'm thinking you have the iterative field data type set to Byte. Anything greater than 255 will cause an error in that case.

[Shank]

@CharlieS and All

I have a similar scenario but for multiple lines, below is the example. How can we get this achieved?

Line	Line from	Line To	Route
1	2022	2060	1
1	2060	1692	0
2	1849	2022	0
2	1842	1849	1
3	1692	1699	1
3	1699	2022	0
3	2022	2025	0