LinkedIn
Twitter
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
