This article demonstrates the use case to generate choice values from a table for users in a form using Run macro and display the results from another table as the output.
...
The SQL database has two tables called "Zone" and "Rules". Users are allowed to select a "zone_id" from the zone Zone table and then use the "zone_id" as a foreign key to select the rules associated with that "zone_id". In the Zone table, "zone_id" is the primary key and "Demog" is the foreign key in the Rules table. Please see below the structure of Zones and Rules tables.
...
| Zone_ID | Zone |
|---|---|
| 200 | Stanislaus |
| 201 | Brower |
| 202 | Alton |
| Demog | Rules |
|---|---|
| 200 | IsDisabled=True |
| 200 | isRequired=False |
| 201 | IsDisabled=False |
| 201 | isRequired=True |
...