Jump to content
Sign in to follow this  
Gogargirl

Finding related records in self-join

Recommended Posts

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.