1 Reply Latest reply on May 7, 2010 4:18 PM by philmodjunk

    list related fields as a value list

    typeleven

      Title

      list related fields as a value list

      Post

      So I have a company table with customers related to it. I want to list all the id's of those cusomers while Im on that company. I would like to make a calc field that will make a multi key that has all those id's in it.

        • 1. Re: list related fields as a value list
          philmodjunk

          This is called a conditional value list:

           

          Here's a thread on setting up conditional value lists:

          Custom Value List?

           

          Use the second option for your type of value list.

           

          Once you have the value list working, you can use the valuelistitems function to put the values in a multivalue key field. (Note: multi-value fields are often used in place of a join table in many to many relationships in Filemaker. While this can be done, it's often better to use a join table instead.)