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.
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.