Primary Key validation

[Former Member]

Hi All,

I have a requirement wherein the Material Number is my primary key field.

I want that whenever a user enters a new material number in MDM a search at the backend should take place and pop me a message saying that this material number already exsists or else does not exists.So that Duplicate Material number creation does not happen.

Can this be done using validation?If so how?

Useful answers will be rewarded

Regards

Simona

[Former Member · Accepted solution]

Hi Simona,

Make the material number as Unique by setting the value yes in Unique Key property of Material it automatically validates the duplicate material number.

Another option is you have to select all the records and put them in the workflow that consists of Validation step but its slightly a vague approach.

Regards,

Jitesh Talreja

[Former Member · Accepted solution]

Thanks Jitesh,

But by making it unique,it gives me a system generated message,what i want is a user generated msg.

You mentioned something abot doing it through MDM validations,can you tell me what can be the expression

Thanks

Simona