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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    SRBENET 
×
×
  • Create New...

Important Information

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