Can somebody please help?

[zenboy32]

I have a relational database that tracks consumers enrolled in 15 different programs. In the “Program” database I have the following fields for each program:

Enrolled (calculation, number) = NotIsEmpty(Enroll Date)

Active (calculation, number) = NotIsEmpty(Enroll Date) and IsEmpty(Cancel Date)

Cancelled (calculation, number) = NotIsEmpty(Cancel Date)

Total Enrolled (summary, Total of Enrolled)

Total Active (summary, Total of Active)

Total Cancelled (summary, Total of Cancelled)

On the main menu of the “Consumer Main Database” I would like to have a button/script that displays the name of each program. When the Program Manager clicks on the name of their program, it will find all consumers served by that program and sort them by last name. Then I would like the Program Managers to have another button/script where they can omit the records of the consumers that have been cancelled. Can somebody please help me with these two scripts? Thank you.

[ August 16, 2001: Message edited by: zenboy ]