Due to many records I try to avoid too many REFs in my tables. REFs produces the REF_ROW viritual columns and makes the sync much slower when you have many records. So I use ENUM instead with the type REF.
But... then I no longer can add a new record to the "child"-table from the dropdown . Only choose from existing data. (when using REF you can ADD - the buttton under "SEARCH"). Does anyone have a tip or a workaround for easily adding new records to the "child" when you are in the form and use ENUM - type REF?
Solved! Go to Solution.
Place the "Valid_If" expression into the "Suggested Values" and make sure the "Allow other values" property is checked. You should then get the "Add" button on the dropdown list like you would in a normal Ref column.
Place the "Valid_If" expression into the "Suggested Values" and make sure the "Allow other values" property is checked. You should then get the "Add" button on the dropdown list like you would in a normal Ref column.
Worked perfectly!! Thanks a lot!!
Worked for me too!
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |