Skip to Content
0
Former Member
Jan 17, 2012 at 07:03 AM

[Help]SQL Query

25 Views

Hello experts,

Want to ask again, it is possible to get the value of ItemCode in RDR1 even if I'm just creating a new transaction?

Here's my query :

SELECT T0.[Price] / 1.12 as Price, T0.[ItemCode] FROM ITM1 T0 WHERE T0.[ItemCode] = --I want to get the ItemCode from ChooseFromList Here
--AND T0.[PriceList] = 1

Thanks,