Conditional valuelists based on repeating field

[Pontus]

How to get this work?

I want a conditional valuelist that is based on the input in a repeating field and takes data from a related file. Sure it works, except for that the valuelist does not update it's condition when moving to next repetition! Simply I have two repeating fields, one with artists and one with tracks. Related files is Artists and Tracks, master file is Albums.

I've taken the Artists into a valuelists. Now when I pick one artist into the Artist field I want the Tracks valuelist to be conditionally based upon the Artist, so only tracks by that artist is shown.

But, as I said the valuelist is only based on the first repetition, how to get it work for next repetition and next and next and next...?

[jasonwood]

I'm sure there is a way to do this... but I think you should really be using a related database instead of repeating fields.

[CobaltSky]

Conditional value lists are relationship driven - they source the values that are related to the current record.

As such, the whole process is specific to the record and the relationship. One relationship produces one set of related records for one record. The only way to use this system to achieve multiple record groupings within one record is to use multiple relationships. Alternatively, of course, you could achieve a comparable effect by using a relational structure and thus having each grouping relating to a different record.

The issue arises because conditional value lists are a relatively recent innovation which build on FileMaker's relational capabilities, whereas repeating fields are a legacy work-around from the ancient days when FileMaker was not yet relational.

It is possible to use an automatic value list selection process (there's a demo of this available from my web site if you want to investigate it) to achieve lists which are driven by scripts rather than relationships, but I suspect that in this instance, a relational solution would be more elegant.

[Pontus]

OK

I'll go and check your code if it's a possible to implement, otherwise I'll have to look on the other ways to do it