Create new Record through a checkbox set
I am creating a billing system for an optometry practice. I would like to be able to select certain codes (diagnostic codes) from a checkbox set that is filtered through a related table based on certain categories (in the photo, the category is "Refractive - General". If I change the category, the checkbox sets will change). This seems to be a very quick and easy way to select certain billing codes.
The problem I am having is that the checkbox set plugs each selected value into the same keyfield, which makes it tough to use the data. Is there any way to be able to select multiple checkbox sets and have some sort of script populate a different related table, creating a new record for each checkbox I select?
Any advice would greatly be appreciated.