Can add duplicate "Value"

Description

None

Environment

None

Activity

Show:
Hiep Lq
January 21, 2014, 7:00 PM

Hi Anna.
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
quote:
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 '_'.

Anna Fadeeva
January 21, 2014, 7:13 PM
Edited

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.

Hiep Lq
January 21, 2014, 7:21 PM

Hi Anna.
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.

Carlos Ruiz
January 22, 2014, 2:10 AM

Anna, you must create additionally a unique index on AD_Client_ID+Value

Regards,

Carlos Ruiz

Anna Fadeeva
January 22, 2014, 7:51 AM

OK, thank you, Carlos & hieplq!
I will do it some later.

Assignee

Carlos Ruiz

Reporter

Anna Fadeeva

Labels

Tested By

None

Components

Affects versions

Priority

Major
Configure