"Production Order"."No." Relation ?

da_neal

Can someone explain why field "No." in "Production Order" has relation to itself?

mohana_cse06

probably to select from reports or any other screens

CharlesZA

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

da_neal

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.