Generate a value list based on repeating field

[ace_bird_dog]

I have a value list generated via a relationship to another FM DB and it's contents are controlled by the values in a repeating field. The problem is that I can only get it to work for the first repetition of the repeating field. Is there a work around?

[-Queue-]

Can you elaborate a bit or stuff and attach the files for us to look at?

[ace_bird_dog]

Thanks for the rapid response. This is related to my other post you just responded to.

The files are attached. There are three files:

1. a color database that lists all the colors the item comes in.

2. a description database that lists the item descriptions.

3. a main database that pulls all that information together.

In the main database, the color lookup only functions properly for the first entry in the item # field. Item 0120000 has Red/White/Blue in the value list which is accurate. For the second entry (#0120001) it should read Gray/Black/White as opposed to Red/White/Blue.

This database is already existing and used extensively so changing to something other than repeating fields is not possible.

Thanks again.

VL_on_repeat.zip

[-Queue-]

You need a calculation field for each item repetition, a relationship between each calc field to the item field in Colors, a value list using the related color field for each relationship, a text color field to hold each result of the selected color from the value lists, a global index field to hold the number of each repetition, and a calculation to combine the individual color fields into a repeating field. (Note: the global and combined calc are only necessary if you want to maintain the colors in a repeating field for some reason; If you don't need to, then they are superfluous.

I've made all the above changes in the attachment and put the single color fields on the layout, aligning them so that they appear to be a repeating field.

I also removed the first character from your filenames since it's not recognized in Windows. So you may need to add it and redefine your relationships appropriately.

ace.zip