Oups !
It's better not modify such a thing.
If you want absolutely have a LookUp on the "No." one solution could be the next :
1/ Go to the "Sales Header" table
2/ Go on the "No." field,
go in the properties of this field and choose TableRelation = "Sales Header".No. AND (this is important) Validate TableRelation = No.
My candle burns by both ends, it will not last the night,
But oh my foes and oh my friends, it gives a lovely light
Comments
It's better not modify such a thing.
If you want absolutely have a LookUp on the "No." one solution could be the next :
1/ Go to the "Sales Header" table
2/ Go on the "No." field,
go in the properties of this field and choose TableRelation = "Sales Header".No. AND (this is important) Validate TableRelation = No.
But oh my foes and oh my friends, it gives a lovely light