Updateable BAQ - BPM for verification of ShipVia Code

You wouldn’t really need a bpm for that. You could create a baq that queries just your shipvia codes. Then under advanced column editor configuration simply change the editor type to dropdown and do data from BAQ, select your BAQ. That would take care of giving them valid shipvia codes. At that point youre not actually having to bring in the shipvia table if you don’t need it for other purposes.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of lissettea.contreras@...
Sent: Thursday, December 12, 2013 10:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Updateable BAQ - BPM for verification of ShipVia Code



Hi!

I am creating an updatable BAQ for the Customer, FOB and ShipVia code to resolve some of the data issues we have. I would like to verify that ShipVia codes are valid values. I know there is a way to do this with a BAQ and creating a pre-processing BPM but I get the error " Unable to find any table in the Query" when I have Customer and ShipVia tables in the query. Any ideas?



[Non-text portions of this message have been removed]
Hi!

I am creating an updatable  BAQ for the Customer, FOB and ShipVia code to resolve some of the data issues we have. I would like to verify that ShipVia codes are valid values. I know there is a way to do this with a BAQ and creating a pre-processing BPM but I get the error " Unable to find any table in the Query" when I have Customer and ShipVia tables in the query. Any ideas?