Jump to content
Sign in to follow this  
Jacob

Pulling up multiple records without using a portal

Recommended Posts

I'm trying to set up a database with at least two relational databases. In one I would like to dump information regarding classes being taught in our department (i.e. number of credit hours, time of day, which classroom, who is the inrtuctor etc.) and in the other database information about each instructor (i.e. tenure?, personal information, research projects etc.). Eventually I would like to create a report with specific personal information, as well as a list of each class that each professor is teaching for a given semester. (which is why I would like the classes in a separate file, one that could be emptied and refilled each term) I would use a portal, but some professors teach many classes, whereas others only have one or two. Is there a way to get an adjustable length of portal for printing, or a way to show all the classes that a professor may be teaching?

Thank you

Jacob

Share this post


Link to post
Share on other sites

Create a value list of the related classes. Then use an unstored calculation of ValueListItems( Status(CurrentFileName), "classvaluelist" ). If you prefer a comma-delimited list of classes, use Substitute( ValueListItems( Status(CurrentFileName), "classvaluelist" ), "

Share this post


Link to post
Share on other sites

Welcome to this Forum, Jacob.

Following Queue's answer...

...Or you could have 3 files B)

Classes.fp5, with ClassID and Class Information

Teachers.fp5, with Teacher ID and Teacher information

TeachersInClass.fp5, with either the ClassID and TeacherID, used to create a Join between Classes and Teachers.

Then your portals would be linked from Classes or Teachers to the TeachersInClass file, from which you'd print your report.

A for the "given semester" parameter, this can be also included in the Join file, so that you won't need to change anything to the Clas record itself.

a compound with TeacherID & " "& gSemester & gYear , where gSemester and gYear are global fields would match an indexed key of TeacherID&" " &SemesterNum& " "&Year.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.