Re: Need SQL*Forms 3 trigger help.
From: Stephen Turner <sturner_at_athena.mit.edu>
Date: 1995/07/20
Message-ID: <3umdvo$4o8_at_senator-bedfellow.MIT.EDU>#1/1
Date: 1995/07/20
Message-ID: <3umdvo$4o8_at_senator-bedfellow.MIT.EDU>#1/1
> I am trying to create a
>version 3 form that will display a count of rows found in a display only
>field.
On first impression, you might try to define 2 views of your table; one which selects distinct SSN, the other which selects distinct AWARD , max AWARD DATE for the award and count for the award.
The form form would then be a simple master-detail affair based on the two views. The challenge, I guess, would be writing the select statements for the second view.
Hope this helps,
Steve Turner
Received on Thu Jul 20 1995 - 00:00:00 CEST