"Production Order"."No." Relation ?

da_neal
da_neal Member Posts: 76
in NAV Three Tier
Can someone explain why field "No." in "Production Order" has relation to itself?

Answers

  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    probably to select from reports or any other screens

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • CharlesZA
    CharlesZA Member Posts: 10
    Hello,

    TableRelation :: "Production Order".No. WHERE (Status=FIELD(Status))

    This is to ensure that the production order number is unique just for that status as the primary key is a combination of these fields. Status,No.

    In the case where there is an insert error you'll receive a more meaningful error message related to that production order status.

    Hope this helps,

    Cheers

    Life runs on code;
  • da_neal
    da_neal Member Posts: 76
    I did not notice a difference in the error messages when I inserted the same record when relation exists an not. That is not reason.

Categories