Hello. I have a table called Settings and here is a sample data
Category | Name |
---|---|
Reason Code | 1 |
Reason Code | 2 |
Reason Code | 3 |
Reason Code | 4 |
Country | 11 |
Country | 12 |
Country | 13 |
Country | 14 |
I have this field in one of my forms and it is an Enum-Ref Type and connected to Settings table and filters the choices under the Reason Code category
When I click the New button in the dropdown, it will open the form in the Settings table
Here are my questions:
-
Since I’m adding an entry in the reason code (first photo) field, is there any way to put the initial value of the the category to Reason Code (second photo)?
-
If the answer in the first question is no, should I create separate table for Reason Code and Country (see sample data above)?