Context: I have two tables, Shots and Videos (with links between). It's possible one shot may be used in more than one video. I will export shots through a CSV into an InDesign template using data merge (Page Builder won't work for other reasons).
Problem: I'm trying to specify a chronological order for the shots to appear.
Ideas that won't work/aren't ideal:
- I could just drag them around into the right order, but since one shot may go into multiple videos, the order may vary by video.
- I could rearrange order of linked shots from Video table side, but that won't work the the CSV export to InDesign.
- I could do a single select list of numbers, but that won't work since each shot may have a different number for each video it's in.
Any other ideas?
