4 gl

[lilyjain]

I want to make smart browser for a table which contain
project code,concern no, activity no and closing date.
Each project can have many concern no,each concern can have many activity no, each activity has a closing date.

In browser I wish to display only those records for each concern no which has maximun date.

poj_code con_no act_no ac_closedate
20 302 1 01/04/02
20 302 2 10/04/02
20 303 1 07/04/02
10 215 1 08/04/02
10 215 2 16/04/02

In browser record no 2,3 and 5 should be display.

How can I achieve this.

 

[Henri de Vos]

I don't think this is possible without using a (temporary) table which is filled with the data you want.