mibuso.com
Home› NAV/Navision Classic Client
Options

Duplicacy Problem-

naushienaushie Member Posts: 33
edited 2004-07-28 in NAV/Navision Classic Client
Well my problem id like this.
I have table service item 5940.In this table the primary key is "No." field.
and this table has one more field called "serial no."
since primary key is the "No." field so we cant have two records of the same "no.".
But what i want is the "serial no." field should also be unique in the table.
now can any one tell me how can i do it.
my main aim is to stop user entering same "serial no" again.

please suggest some one how can i do it.
Naushad Alam
Consultant -Navision

All e Technologies (P) Ltd.
Building Solutions for Extended Enterprises

www.alletec.com

Comments

  • Options
    FPulsfortFPulsfort Member Posts: 43
    You have to programm it in the OnValidate-Trigger of the field "Serial no.". Make a variable of type record and subtype "Service item". Then search with setrange for the entered serial no. If you find a record give an error-message.

    Hope this helps.

    Regards,
    Frank
  • Options
    naushienaushie Member Posts: 33
    hi
    i have done it thanks for the suggestion.
    Naushad Alam
    Consultant -Navision

    All e Technologies (P) Ltd.
    Building Solutions for Extended Enterprises

    www.alletec.com
Sign In or Register to comment.