Doing a school reporting database. In one particular layout each pupil has normal data ( forename, surname, subject, class etc) but also has 3 strategies fields which staff can use to choose strategies an individual pupil may use to help them with a particular subject. The 3 strategies fields are formated to use a pop-up menu from a related database, which has only 2 fields: subject and strategy. For example "Music" and "Practise your instrument more".

The problem is when I do a find for a particular class the records take about 2 seconds each to appear in list view. I know its got something to do with the strategies fields being relational, because when I delete only these fields from the layout the whole class's records appears almost at once.

There are 16 school subjects each with 20 different strategies. Should it take so long to find and display the pupils data, or is it simply because each of the 3 strategy fields needs to individually link to the related database file. Thus slowing down the find.

I am using FM6.

Edited September 9, 200520 yr by Guest

Since you can't exploit the new fancy GTRR features arrived with FM8, could you try to dissect these tamplates ...because as it is with your version will a search in value a relation away be unstored - checkout:

http://www.kevinfrank.com/download/multi-gtrr.sit

--sd