Unexpected results when linking records and using Groupings
Hi all — I have a table with 1000+ TV shows and movies that I’m exporting in A-Z order so they can be laid out in Indesign. We’ll call this Table 1. But I also want to create lists with those shows following a simple hierarchy:
Grouping (Drama, Comedy, Reality, etc.)
List (Cop Dramas, Med Dramas, Intense Dramas, etc.)
Show #1
… 2. Show #2
etc.
To accomplish this I created Table 2, and used Link fields to tie the shows in Table 1 to the lists in Table 2. Everything went great for a while. To build a list in Table 2, I would assign a show in Table 1 to a list in Table 2, then duplicate the line and link it to a different show.
Where I got myself into trouble — and I can’t find a way out — is that I did a shortcut. I started creating lists on the fly in Table 1. Not Table 2. At the time I noticed I wasn’t being asked to link the list to a grouping, but I think “well, I can do that later.” But I found I couldn’t. Jumping over to Table 2 I saw all my new lists … but they weren’t a
