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 ?