Changing some of my old-fashioned practices

[brainonastick]

Hi there,

 

I have a tendency to create too many relationships in Filemaker.

Currently I use globals to set up portals that need to see all related records with a particular status. I know I can use portal filters but if the related table has thousands of records and I use a filter it takes ages to index and display. 

 

I also like having portals that change what they display based on a Finder field that forms part of the relationship. For instance "courseNameFinder" where you enter the first 4 words of a course name is related to a field in the related table called "courseName1st4Words" which is a calculation e.g. LeftWords(courseName, 4). So I need a separate relationship for each finder field - there might be others such as "courseDateFinder", "courseCodeFinder" and so on.

 

If there are better ways to deal with either of these issues please let me know.

 

 

 

 

[comment]

See if this can spark some ideas:

http://fmforums.com/forum/topic/39253-filtering-portal-with-multiple-radio-buttons/?p=183004