I avoid Centura as often as possible and used to use them a lot and have been lucky enough to use Crystal the past fews years. However, it seems I have gotten rusty and just need to add a simple query to the QRP VMWRQRP1.QRP....I need the Qty on Hand and Product Code from the Part table.
I had used SELECT QTY_ON_HAND FROM PART WHERE ID = :WORKORDER_PART_ID
I just wanted to get the qty then work towards the Product code. Lol as you can see Rusty!
Any help folks?