I've got this entire table filled with itineraries. These are linked to a main holiday record in a related table. I have one record per day, some days can have multiple locations.
What I need is a record per location, not day, as well as providing the order as a number in a separate Order field for those that have multiple locations in the same day. I also need all the other fields to be duplicated into the 'duplicated' ones.
Here, I would need two records for DayNumber = 7:
- 7 - Chalon-Sure-Saône - 1
- 7 - Beaune - 2
I've managed to make a list out of those locations by substituting the dividing character. But I've got no idea where to go from there.