Hi everyone! I am creating an application to manage information about chemical products, and I hope you can help me with this question.
The app generates a report with the chemical safety data. For this, I created a form where the user selects for which product they want the report. I want the user to be able to customize the information that is shown in the report using multiple option buttons. Here is an example of what I want to achieve.
This is the report template:
As you can see, the section “Physical and Chemical properties” is a textbox that concatenates multiple fields, but I want the user to choose which properties will be displayed in the report. Here is an example of the form:
So, if the user only selects “Appearance” and “Density”, the “Physical and Chemical properties” textbox in the report should only concatenates [FieldAppearance]&[FieldDensity].
Does anyone know how I can accomplish this?