Okay,I have a database for summerschool registration that I'm working on, I need a report to generate a list of students for any class that has been entered into the "Class" table so that if you would Select "Science 101" or similar you could call up a list of students in Science 101 any ideas?

This thread should solve your problem... check out the attachments

http://www.fmforums.com/threads/showflat...true#Post105780

I checked out the attachments but I need a list view of all of the students that is completely printable and scaleable, IE if there are 200 students then there would be 20 students on a page with ten pages etc. Portals do not seem to behave the way I need them to to do this.

oh... then you need to use script maker....

Create a student layout, design it as a list view in browse mode. On the header, either create a value list that has all class name/number on it, create an edit box that the user can enter the class name/number, or use a pop up layout that the user can select.

Then, use the free hidden plug-in (databasepros.com search hidden plug-ins), and use the on field change event, link it to a script (make a search for the class name).... It will then list all the student of that class.

Danke Much

Okay, I can't seem to get it to work right, I first need a list that is dynamic that I can have that lists all given classes plus a blank space, when the user selects a class I need a find to be performed that matches the course (one field one of two possible repetitions)of the student record to the selected course in the pop up menu, it doesn't seem to work at all... what am I doing wrong? any advice would be apreciated.

I need the scaleable class list because the Classes are in a diffrent table and entered seprately that way you can delete all of the students or export them as a backup and start with a clean slate of students but have a list of avaliable classes for the next year as this rarely changes