Here is my challenge that I am trying to solve. I have a database with over 300 sites, and 5000 objects at those sites. The sites get updates monthly, and the objects get updated weekly. Uploading one master sheet and building this survey tool is the most effective way to mange.
So here is the basis of what I have. Currently have a table with two reference columns that create dynamic enum lists for each. [Sites] and [Objects]. These are EnumLists, with the base type of Ref and the ‘Main’ as the table referenced above. This portion works great.
What I need… is we have 5 areas of conditioning that needs to be done on each object per site visit. I’ve got a form created that has each area in a tab, and the EnumList of the objects below. My challenge is that ALL of the listed objects must be conditioned each visit, and each object can only be conditioned in on category.
Good Condition - Tab (header row)
Fair Condition - Tab (header row)
If the user selected Object 2 and 3 in the ‘good’ tab, I would want those to be eliminated as selections in the ‘fair’ tab. Only Object 1 would be listed as only it would be selected. Finally, before submitting, if any object had not been conditioned, it would be listed on a ‘missing’ list, and require the user to go back and condition.
Any help is appreciated!