Let's assume that I have a truck going to different cities. For instant, let's assume I have only 2 cities (which are A and B). I want to make a table, that is linked to the truck. The table has 3 columns and dynamic rows. The column is: From, to, and time. The rows are created only when I visit the city. So, the first row is created when I went from origin A and sunk at depot B. The table will be filled as follows:
From I To I Time
1 : 2 : 3:00
I don't care about how the table looks, it is just only an example. Then; if I went back to point A from B the table will be as follows:
From I To I Time
1 : 2 : 3:00
2 : 1 : 2:30
let's say I have added another city later, which is C: then if I dispatched as follows: A, C, B (where city rank are A:1, B:2, C:3) the new table will be as followed:
From I To I Time
1 : 2: 3:00
2 : 1 : 2:30
1 : 3: 1:00
3 : 2 : 1:20
If I return the truck from B to C then to A, the table will again be shown as follows:
From I To I Time
1 : 2: 3:00
2 : 1 : 2:30
1 : 3: 1:00
3 : 2 : 1:20
2 : 3: 0:50
3: 1: 0:45
I prefer to have a transcript to make the table if it is possible.
