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

expressions
(Shivaprakash TS) #1

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?

(Rogério Penna) #2

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) #3

@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.

(Rogério Penna) #4

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) #5

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

(Rogério Penna) #6

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.

(Rogério Penna) #7

@Shivaprakash_TS did it work with REF?