2 Replies Latest reply on Jul 10, 2014 9:03 AM by strngr12

    Filemaker 8 ValueListItems Question

    strngr12

      I have a Filemaker doc with two tables called "data" and "ID."

      Both tables have a field caleld "name."

      I have a relationship between the two defined as data::name = ID::name

      In the ID table, in addition to the name field, I have a field called "ID."

      In the data table I have a field caled "IDs." It is a calculation field:

       

      Substitute ( List ( ID::ID ) ; "¶" ; " " )

       

      This does exactly what you'd expect. It gives me all the related IDs from the ID::ID field in a list and, if there is more than one, gives me them with just a space inbetween.

       

      I use this in a script where I set a variable - $Id = data::IDs

       

      I have a new client that is on Filemaker 8, however, and the List command does not work on anything lower than 8.5.

       

      I understand that there is a way to get the list of IDs from the ID table into a value list and then only display the values from the value list from a related record in a field but can't figure out how to do this.

       

      Do I have to do something to the ID::ID field?

       

      How do I define the value list?

       

      How do I get only related IDs to show up in data::ID?

       

      Any help would be appreciated.

       

      thanks!

       

      Dan