Skip to Content
0
Former Member
Mar 04, 2009 at 05:50 PM

Question about query for a field in a marketing document

30 Views

Hi, I need to fill a user field in the detail section of each marketing document, the following query is used for the order document. My question is, since I have to specify the table (RDR1), do I needo to create a new query for each type of document (Quote, Order, Invoice, etc) ?

Thank you in advance!

SELECT T0.SalPackMsr FROM OITM T0 WHERE T0.[ItemCode] = $[RDR1.ITEMCODE]