Skip to Content
avatar image
Former Member

Primary Key validation

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    May 20, 2008 at 06:06 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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