I would do this with a 4GL BPM Action on SalesOrder.Update() for creates (and potentially additions, or deletes if you want the number to be really accurate) of OrderDtl. You won't be able to do this with a BAQ -- you need a trigger and an action, which is what a BPM is for.
There is at least one member of this list who does just this kind of consulting work for very reasonable rates. If he doesn't contact you offline let me know.
-bws
--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of timdines@...
Sent: Monday, February 22, 2010 1:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] I'm Lost
I don't know if I'm too tired today or what, but I am lost. I have a BAQ created that tells me the total pieces shipped to a customer since the first of the year. I need to put this number into OrdDtl.Number02, but I don't know how to get it there.
Is there a decent piece of documentation anywhere that can help educate me on this?
Tim Dines
Steel Parts Manufacturing, Inc.
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
There is at least one member of this list who does just this kind of consulting work for very reasonable rates. If he doesn't contact you offline let me know.
-bws
--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of timdines@...
Sent: Monday, February 22, 2010 1:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] I'm Lost
I don't know if I'm too tired today or what, but I am lost. I have a BAQ created that tells me the total pieces shipped to a customer since the first of the year. I need to put this number into OrdDtl.Number02, but I don't know how to get it there.
Is there a decent piece of documentation anywhere that can help educate me on this?
Tim Dines
Steel Parts Manufacturing, Inc.
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links