I have an old FM6 database which I'm bringing up to FM13. It's a single table. One of the text fields is "characters" (people), which links to a value list. However, each record seems to have the ability to have up to four values, each selected separately with a dropdown list. There aren't four separate selectable fields - it really is just one field. Of course, the field actually contains "Person 1, Person 2, Person 3, Person 4" but what puzzles me is the ability to set up multiple dropdown selectors for this.
Is this a feature that later versions of Filemaker still have? I know that it should properly be handled with a related table / portals, but for now I'd like to keep the schema/data as close as possible to the original if possible.
I literally found the answer two minutes after I asked. It's "repeating fields", a feature that's still available (although often better to do related table w/portal) . Here's the relevant article: