In my app there is column Customer Name. What...

[Shivaprakash_TS]

In my app there is column Customer Name. What I want is in this column it should show already existing names for entry or it should allow to add new name. I set the column for enumlist but somewhere the expression has gone wrong. Can some one help me on this?

[Rogerio_Penna]

do you want to be able to select a single or multiple names.

if a single name, ENUM, if multiple names, ENUMLIST

Then in VALID_IF field of the column, use

tablename[columnname]

I suppose the previous list of costumer names is located in another table or column, right?

[Shivaprakash_TS]

@Rogerio_Penna its single name.name list from tge same column. I tried valid if but it shows only the names available in that column but no option for adding new names.

[Rogerio_Penna]

I am actually going through the same problem.

Made a search in the forum… MAYBE if instead of an ENUM type, you set the column with the same type as the source column (text or name) and still use the VALID_IF…

[Shivaprakash_TS]

@Rogerio_Penna In such case we cannot add new names to the column

[Rogerio_Penna]

Found another topic saying you can only add new items to a list IF you use a REF type column. Then there is the option for NEW.

[Rogerio_Penna]

@Shivaprakash_TS did it work with REF?