Sorting and Relationships

[bgscott]

I have an application where some of the related files will reside on removable media.  When sorting, a message box appears telling the user that the related file (which is not on the server) can not be opened (Not Found) and asks the user to locate it.  The related file may or may not be available on the removable media and is not needed for the purposes of the sort.

Is there anyway to prevent this message from appearing?  Error capture on does not solve the problem

[rwoods]

Hello

FileMaker will ask for the related files whenever it thinks it *might* need them. When entering the sort dialog there may be related fields on the current layout, so it will need to display their name in the list of fields that you can sort on, so it will need the files.

Also, if any of the fields that could be sorted on are calculated and need the related files, it will ask for them. There may be other reasons why FM's internal engine wants to check the related files.

You will have to experiment, perhaps you can script a layout change to a layout that only has fields on it that don't need the related files, and maybe that will help. Anything that removes the possibility of needing to check the related files would help.

Or you may find that FileMaker will just do this whether you like it or not.

 

Edited May 6, 2021 by rwoods