Ron,
I would create a calculation that concatenates the "Program, Year,
Term and Session" into one field. Use the "&" symbol to join text
fragments together. In this case the calculation for your field
_cClassName might look like this:
ProgramField & " " & Yearfield & " " & TermField & " " &
SessionField
Then I would use a two-value value list popup to display those
classes: the ClassID and _cClassName. Set it to display only the
second value. Add the popup and value list to a new global field you
place on your layout. When the choice is made it will put the ClassID
into the global which you can use as the "parent" side of a
relationship to all the registrations for that class. You can list the
related registrations in an adjoining portal using that relationship.
Alternatively you can use a GTRR to go to a list view report of the
records.
Create another relationship from that global back to the classes
table's ClassID. Use _cClassName for a layout field to place on top of
the global. Give it some non-transparent value for its fill color and
turn off access for it in browse mode. When you click there you will
go to the global field and when you are done selecting the value you
will see the name of your choice displayed. If you use the GTRR option
place the _cClassName field in the header of the report. Simply use
the Class table occurrence that is the parent TO of the registrations
in the report.
j.
On Nov 11, 2008, at 11:27 AM, Ron wrote:
Given that I have a table of Classes, one record for each instance
of a class taught in an organization
And
A table of Registrations for each class, one record per registration
I want to create an Enrollment report, showing all of the
registrations for a specific Class.
Now, how do I allow the user to select a specific class to report on?
Class has ClassID as the key, but the class is more properly
described by Program, Year, Term and Session.
I am trying to find a way to list all of the classes by those
criteria, and allow the user to select one to report on.
FM Pro 8.5 advanced, Windows
Any ideas?
Many thanks!
Ron
--
Jonathan Fletcher
[EMAIL PROTECTED]
Project Foreman
NewMedia Construction Co.
