Jump to content
Sign in to follow this  
ace_bird_dog

Generate a value list based on repeating field

Recommended Posts

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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.