Quick way to ADD a new record when using ENUM - REF?

[KON_TROLL]

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?

[WillowMobileSys · Accepted 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.

[KON_TROLL]

Worked perfectly!! Thanks a lot!!

[feenyjamie]

Worked for me too!