Maybe identifier is not for prevent duplicate record.
for prevent duplicate record. please ref tab "Index column" at window "table and column", it has check box "unique"
for use identifier ref:http://wiki.compiere.com/display/docs/Data+Dictionary
Identifier indicates what displays in the field or drop down list when a user selects it. For example, when the user selects a Partner Group, the Partner Group Name not the Partner Group ID displays. It is possible to have multiple Identifiers defined and the fields will display separated by an '_'.
Hi hieplq !
The "Value" must be unique by default. See the "Product", "Business partner" etc.. and compare settings, please.
Maybe you can tell what settings are missing?
My screenshotes are for example.
Product, Business partner has "Index column" for column value
goto head tab of window "table and column" you can see a child tab "column index"
unique of value is define here.
Anna, you must create additionally a unique index on AD_Client_ID+Value
OK, thank you, Carlos & hieplq!
I will do it some later.