I was after some advice on a problem I have.

I have a database in which teachers are developing a Unit of Work. Once the Unit has been created, they must input all the activities for that Unit. There may be a small number or there may be many.

I decided to have a portal in the main file that relates to another file (activities) sitting off by itself. The relationship allows teachers to input as many activities as they like and I have created a script to print the activities in the activities file.

The problem is, the relationship doesn't work properly, the activities go into the portal, but when you go to the activities file and sort, it only prints the first record. I think the problem is in the fields that are in the relationship, but I have chased my tail around trying to find a correct relationship that I have confused myself and would love some outside help.

The activities file doesn't relate to any other file - is there something I have missed ?

Hi, grant. So, printing from the Activities file, you only see one activity? If this issue only occurs after you've sorted, i suspect the problem may have less to do with any relationship than it does with using sub-summaries on your layout. Try changing any sub-summary part in the layout to a body part, and see if that works better. If you already have a body part, move your fields and text into there and delete the sub-summary part.

HTH,

Jerry

Oh, also, please update your profile. It's very helpful to know what Filemaker version and what OS you are using.