Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

changing value lists based on field - help!


This topic is 7279 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

Hi,

I'm trying to have a changing value lists field by a case calculation based on field "project". Ex. "project 1" has 2 value lists "categories" & "items" from fields in two other related files, as does "project2" and so on. I'm having trouble with one of the resulting "items" value lists - only 5 out of 103 values in the list appear. The calculation for "items_calc" is:

Case(project = "00 4086", ValueListItems("main.fp5", "4086_items")) &

Case(project = "03 3627", ValueListItems("main.fp5", "3627_items"))

The trouble is with the "3627_items" list. In the "items_calc" field all items appear. However, in the "items" field, which is a pop-up menu using value list based on "items_calc" field, only the first 5 items are available for selection. Any ideas on what could be wrong?

Thanks,

Alvise

This topic is 7279 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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