"The Record variable must belong to 38 and not to 37&qu

jaustin

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?

Savatage

Purchase Order No is already part of the sales line table field #71

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.?