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)?
Thank you for your reply Steve and Aurelien.
Yes, I can add Reason Code for the initial value when Iโm adding an entry in this field.
But when Iโm adding a new country, the initial value of the category column should be Country too. Is this possible? Thanks
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |