You can still do it with a baq dataview, I’ve done it a few times, it’s 9:30pm here so I’m not firing up my computer to find you an example, have a look at some of @Carson Ripples examples, he’s good at them
public void PartPriceManBAQDV()
{
partPriceManBAQDV = new BAQDataView("TWG_Quote_Part_Price_DV");
oTrans.Add("TWG_PartPriceMan", partPriceManBAQDV);
string pub16Binding = "JobMtl.PartNum";
IPublisher pub16 = oTrans.GetPublisher(pub16Binding);
if (pub16 == null)
{
string pubName = Guid.NewGuid().ToString();
oTrans.PublishColumnChange(pub16Binding, pubName);
pub16 = oTrans.GetPublisher(pub16Binding);
}
if (pub16 != null)
partPriceManBAQDV.SubscribeToPublisher(pub16.PublishName, "Part_PartNum");
}
EDIT
Create a BAQ with 2 columns, one with CustNum and another with the other field that you want to return
Then publish the OrderHed.CustNum to the BAQ
Disclaimer: Field names may not be correct…