Thanks. That idea did occur to me but it seemed klutzy: glad to have it substantiated! Ron
-----Original Message----- From: FileMaker Pro Discussions [mailto:[EMAIL PROTECTED] On Behalf Of Jonathan Fletcher Sent: Tuesday, November 11, 2008 3:34 PM To: [email protected] Subject: Re: How to select input to a report. 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.
