Cannot join PORel to TranGLC in a designed query

[ckrusen (Calvin Krusen)]

See the following. It kind of goes the opposite direction than you need, and does a lot more.

But you should be able to follow it to make a variable of type string, set it to the PO num, then use the variable in the query against TranGLC

UD Table Relations - data type error - Number of Rows in xxx query

I’m just guessing at what you’re end goal is… But here’s a MD that prevents a UD40 record from being created if Key1 <> an existing InvcHead.InvoiceNum [image] It uses two variables [image] intKey1 is Key1 in Integer form InvcNum is the InvoiceNum when an invoice number matching Key1 is found. If no invoice exists, InvcNum is set to -1 The first widget converts the Key1 to an integer and stores it in intKey1 [image] The second widget finds an invoice with InvoiceNum = Key1. If no inv…