Need help : How to display all related records without portal

[hkarema]

Hi all,

I have two file for record students grade that contain these fields

Student File:

Student ID (text)

Grades File:

S/N (text, auto entered)

Student ID (text)

Subject (text)

Grade (text)

Comment (text)

Performance Score (text)

I build a relationship between the student file and the grades file using the Student ID field as the key field (match field).Now I create a layout in the student file to print a report for each student with all the subjects and the grades that she/he achieved.

From what I read in the manual, that the way to display all related records in the master file is to use a portal. Is there any way I can print all the related records (in this case all of the subjects that the student choose) without using a portal, and at the end of the report, I able to print the performance score.?

Maybe this issues has been discussed before, If it was, could anyone tell me where can I found the solution? If it wasn

[LiveOak]

This is a VERY common question. The way to print a report showing the related records is to print from the Grades file. The general format for your report layout would be:

Header

Subsummary by Student Last Name (leading)

Body <--- grade records

Subsummary by Student Last Name (trailing)

Footer

Display the student's information stored in the Student file using a reverse relationship based upon Student ID. Place the related fields in the subsummary parts of the report created in the Grades file.

If you wish to only print one student, you can use the Go to Related Records (show only related records) script step to isolate the grade records for that student (step run in the Student file).

This is better than using portals, as portals have a set limited size. This approach is commonly used with Invoices and their line items, etc.

-bd

[hkarema]

Hi...

Thank you for your answer. So, from your answer, if I want to print all related records (grades) then I should do it from the grade files. Is there any way, I can print all related records from the student file (master file). The reason I want to do this is because I want to share this database, so I think it will be easier and secure, if all user can do the input process and generating a report process from one file.

If you have any suggestions, tips/tricks how can I do this I will be more than happy to hear that.

Once again thank you in advance.

Regards

Henry