I'm trying to add the "Purchase Order No." field onto the Sales Order Subform (#46). Using the designer, I add the field to the form but get an error "The Record variable must belong to 38 and not to 37" when I compile the form.
I see that the Purchase Order No. field, in the Sales Line table (#37), has a TableRelation of "IF (Drop Shipment=CONST(Yes)) "Purchase Header".No. WHERE (Document Type=CONST(Order))".
I assume that this may be part of the problem but my Drop Shipment fields are all blank. Any idea's?
0
Comments
Just find it & drop it in the form.
My TableRelation says: "Purchase Header".No. WHERE (Document Type=CONST(Order))
Are you sure you're not looking at the table relation of
Purch. Order Line No.?
http://www.BiloBeauty.com
http://www.autismspeaks.org