I've been through all of the articles and attempted to implement, but none of them were what I am looking work.
Since Forms still does not have the ability to assign lookup data to checkboxes, I am having the data placed into single line fields at the bottom.
Current process - based on a unique ID (SIC1234) the lookups pull back the materials and where they are stored. There are several other columns in the databse that are either a '1' for yes or '0'. These indicate management practices for that particular facility.
I'm looking for the JS code that would tick each box associated with the single line field.
Table Class (if needed) is .FuelsMaterialStorageTbl
Checkbox class inside the table is .FuelsMMPCheckbox
Each checkbox option has been shortened to an acroynm for easier use. Screenshots are below:
Form that loads the material and location based on DB lookup (these are seperate tables because I couldn't get "append new rows" to work with multiple material types.
These are the hidden fields that are either 1 or 0 based on DB lookup.
Test DB
Checkbox Values:
I just need to know the best way to associate that when ISP_Hidden_Fuels_MMP_None is 1, that the "none" checkbox is selected.
ISP_Hidden_Fuelds_MMP_SPP is 1, the Spill Prevention Program checkbox is selected.
And so on.
Thank you in advance, I truly appreciate the help.