AnsweredAssumed Answered

Filemaker 8 ValueListItems Question

Question asked by strngr12 on Jul 9, 2014
Latest reply on Jul 10, 2014 by 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.