hello alpha teachers ....
i have this table with this fields(coulms) and values ( rows )
S_ ------------ ref_number ---------- qutatio_name---------- Qutation_Number------------ qutued_Amount ------- last_date
01------------- 1--------------- Finishing Work -------------- 199991 ----------------- 1000000000 ----------- 22/12/2011
02------------- 1--------------- Finishing Work -------------- 1999931 ----------------- 1000000000 ----------- 25/12/2011
03------------- 2--------------- Finishing Work -------------- 1994441 ----------------- 1000000000 ----------- 21/12/2011
04------------- 2--------------- Finishing Work -------------- 1994441 ----------------- 1000000000 ----------- 27/12/2011
05------------- 2--------------- Finishing Work -------------- 1994441 ----------------- 1000000000 ----------- 21/12/2011
06------------- 3--------------- Finishing Work -------------- 1994441 ----------------- 1000000000 ----------- 29/12/2011
07------------- 3--------------- Finishing Work -------------- 1994441 ----------------- 1000000000 ----------- 30/12/2011
i want to filter my grid which connectd to the above dbf table that has the above value .. and the result in the grid shoud be
( Maximum date for each reference ... ref_Number will not dublicate ) so the data will be show in the grid as :
S_ ------------ ref_number ---------- qutatio_name---------- Qutation_Number------------ qutued_Amount ------- last_date
02------------- 1--------------- Finishing Work -------------- 1999931 ----------------- 1000000000 ----------- 25/12/2011
04------------- 2--------------- Finishing Work -------------- 1994441 ----------------- 1000000000 ----------- 27/12/2011
07------------- 3--------------- Finishing Work -------------- 1994441 ----------------- 1000000000 ----------- 30/12/2011
i know this shoud be simple using alpha :)
help any one ?
i have this table with this fields(coulms) and values ( rows )
S_ ------------ ref_number ---------- qutatio_name---------- Qutation_Number------------ qutued_Amount ------- last_date
01------------- 1--------------- Finishing Work -------------- 199991 ----------------- 1000000000 ----------- 22/12/2011
02------------- 1--------------- Finishing Work -------------- 1999931 ----------------- 1000000000 ----------- 25/12/2011
03------------- 2--------------- Finishing Work -------------- 1994441 ----------------- 1000000000 ----------- 21/12/2011
04------------- 2--------------- Finishing Work -------------- 1994441 ----------------- 1000000000 ----------- 27/12/2011
05------------- 2--------------- Finishing Work -------------- 1994441 ----------------- 1000000000 ----------- 21/12/2011
06------------- 3--------------- Finishing Work -------------- 1994441 ----------------- 1000000000 ----------- 29/12/2011
07------------- 3--------------- Finishing Work -------------- 1994441 ----------------- 1000000000 ----------- 30/12/2011
i want to filter my grid which connectd to the above dbf table that has the above value .. and the result in the grid shoud be
( Maximum date for each reference ... ref_Number will not dublicate ) so the data will be show in the grid as :
S_ ------------ ref_number ---------- qutatio_name---------- Qutation_Number------------ qutued_Amount ------- last_date
02------------- 1--------------- Finishing Work -------------- 1999931 ----------------- 1000000000 ----------- 25/12/2011
04------------- 2--------------- Finishing Work -------------- 1994441 ----------------- 1000000000 ----------- 27/12/2011
07------------- 3--------------- Finishing Work -------------- 1994441 ----------------- 1000000000 ----------- 30/12/2011
i know this shoud be simple using alpha :)
help any one ?