AnsweredAssumed Answered

Create new records based on value list from single record

Question asked by celineladoire on Sep 28, 2018
Latest reply on Oct 12, 2018 by mikebeargie


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.

 

For example:

Screen Shot 2018-09-28 at 12.43.20.png

 

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.

Outcomes