Finding related records in self-join

[Gogargirl]

I have a layout with the main record in the header and related records from a self-join relationship showing in a portal in the body. All OK, except it won't print the second page when necessary.

Having seen the other posts about printing data in portals, I'm trying to take the alternative route and find the other (parent) records themselves and then print them out in list form.

Every time I try and do a search in the related field, I get the following error message:

"FileMaker Pro.e.exe has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created."

And guess what, every time this happens the file needs recovering. And I haven't got a clue where the error log is.

The match fields in the relationship are a text calculation field on the 'left' which concatenates data from 60 different key fields, so forming a 'multi-key', and a normal text field on the right. I use numbers in the match fields, but both are defined as text fields so the relationship will work.

So how please do I find the related records?

[SteveB]

I don't know about finding the related records, but you shouldn't be blowing up FM and clobbering your data file(s). Fixing this would be my first priority. Have you re-installed Filemaker? If that doesn't fix the blow ups, you might try re-doing the relationships, since one of them could be bad even thought they all appear fine.

[danjacoby]

While you're at it, try running some disk utilities and virus detection as well. Things like this don't just happen -- there's something seriously wrong. And you want to make sure you catch whatever it is before it gets worse.

[Gogargirl]

Thanks very much for your suggestions. I ran all the disk utilities (no problems found), reinstalled Filemaker and recreated the relationships and their dependent fields. Filemaker now just shuts down instantly without even an error message when I try a find request in the related field.

I created a new file with exactly the same structure and it's OK, so I guess I'll just junk the old file and leave well alone.

As they say.......weird!