Skip to Content
0
Former Member
Nov 25, 2010 at 11:53 AM

Problem in Choose From List based on Recordset Query

35 Views

Hello All,

I want to create a choose From List which will fetch data from Sales Order Table based on a query .

Query -> Select DocEntry From ORDR T0,RDR1 T1 Where T0.DocEntry=T1.DocEntry and T1.OpenQty > 0

condidtion will be based on DocEntry of Sales Order.

How to assign query to the cfl so that 10 to 20 records will be showing in the cfl.

Thanks & Regards,

Amit