Jump to content
Sign in to follow this  
TBS

Terminate Relationships

Recommended Posts

I have realtionships that I would like to teminate after a specified date. Once a certain date is trigerred I reference a local field and no longer need the Related File to be referenced. Is there a way to do this? Thanks in advance!

Share this post


Link to post
Share on other sites

You should have wrote that into your pre-nub. smile.gif

but the answer is no, you can't. There isn't really a reason to either...

Share this post


Link to post
Share on other sites

You could do that with a calculated key.

Just make the key change to "Invalid", or "Expired" or something else that it would never find a match to on the other side if the criteria is not met.

As long as there are no globals or other related fields in the calculation it can be indexed and a relationship can be created.

Share this post


Link to post
Share on other sites

The main reason for this is to stop the file from referencing and opening another file that is no longer needed. Thanks for the reply, clever idea for a prenub wink.gif

Share this post


Link to post
Share on other sites

I think you will find that it will open the file regardless. Reason being is because it will always look for a match regardless.

My suggestion will only create a no match situation, but FileMaker will still need to open the file to determine this.

The only way to keep FileMaker from opening the file is to not reference, display, edit, calculate anything that refers to that relationship. Othewise, the file must open.

Share this post


Link to post
Share on other sites

The only way to keep FileMaker from opening the file is to not reference, display, edit, calculate anything that refers to that relationship. Othewise, the file must open.

Quite true, however there may be a way...

The Case function is notable for the fact that it calculates only to the point where a valid result is returned, and any redundant syntax which follows is ignored. Therefore if the only reference within the file which uses the relationship is at the tail of a case function, viz:

Case(Status(CurrentDate) > RefDate + 9, LocalField, RelatedFile::RelatedField)

...then (in this example) the calc field will reference the related file until ten days have elapsed since RefDate, but after that, should ignore it entirely (and should not open it since it will not be referenced).

I've tried it out and it seems to work here with v5.5. Give it a try and see if it does what you want.

Share this post


Link to post
Share on other sites

Somewhat picky point, but I think the Case function performs all the calculations, but selects the first match. Might be significant in something that takes a long time to evaluate.

-bd

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  

  • Who Viewed the Topic

    1 member has viewed this topic:
    AlanTrewartha 
×
×
  • Create New...

Important Information

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