1 Reply Latest reply on Apr 3, 2016 2:10 PM by lokinyc

    Multiple values in one text field - use multiple dropdown selectors?

    lokinyc

      Hi

       

      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.


      Thanks!

       

      Matt