Conditional Numerical Value List

[higleyjp]

I'm working on an inspection app to be used on iPads using FM Go in the field. The inspection type I'm currently working on requires that elements receive different weight across multiple categories. I have already entered the maximum valid values for each element into the database, and have been using validation to ensure that the user-entered score for that element is less than or equal to the max allowed value. Instead of using free-form data entry I would like to implement a pop-up menu, but I'm not sure how to populate the value list to show integers 1 through the maximum allowed score.

Thanks in advance!

[comment]

What's the largest overall value?

[higleyjp]

What's the largest overall value?

Could be up to 100, but nearly all are between 1 & 10.

[comment]

Well, here's one to look at it, I suppose:

MaxValue.zip

[higleyjp]

I've never used repeating fields, but they seem very interesting. Thanks!

When I try and use the cValuesR field as the source for a pop-up menu, however, it shows the largest value from the entire found set. Is there a way to make the value list reference only the specific related record? I tried to add a self-join to tie it only to the one record, but that didn't work out very well. The value list dwindled when a value lower than the max was chosen for the first record, and then the pop-up menu did not function at all if attempted with any further records after that.

[comment]

I am afraid you have lost me.

Is there a way to make the value list reference only the specific related record?

Isn't that how it works in my file?