Jump to content

Finding related records in self-join


Gogargirl
 Share

This topic is 7155 days old. Please don't post here. Open a new topic instead.

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?

Link to comment
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.

Link to comment
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!

Link to comment
Share on other sites

This topic is 7155 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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