higleyjp Posted July 14, 2011 Posted July 14, 2011 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!
higleyjp Posted July 15, 2011 Author Posted July 15, 2011 What's the largest overall value? Could be up to 100, but nearly all are between 1 & 10.
comment Posted July 15, 2011 Posted July 15, 2011 Well, here's one to look at it, I suppose: MaxValue.zip
higleyjp Posted July 15, 2011 Author Posted July 15, 2011 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 Posted July 15, 2011 Posted July 15, 2011 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?
Recommended Posts
This topic is 4888 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 accountSign in
Already have an account? Sign in here.
Sign In Now