filter working intermitently

[MuonDude]

Using FM Adv. 8.5

I have two files:

UI_file.fp7

doclib.fp7

I want to provide users a way to assign publishers and authors to a document from a list of each. The list should dwindle based on already assigned authors or publishers.

In the UI file I have a pop-up with portal showing the list of not-related publishers (for example). This is working and is based on a List() function calc in the doclib file.

As this number of rows in the portal grows I'd like to be able to filter this list using a VL (A-Z). The attached screen shots show the TOG, the pop-up picker window and the relationships.

There is a separate pop-up for authors and publishers. The base table Doc has separate globals for the match fields and a separate pair of unstored calcs for the match low/high. These values are getting set correctly (I can use the data viewer or just display them on the pop-up layout). However, I don't get consistent behavior. Sometimes the author picker filter works and sometimes the publisher picker filter works, they seem to alternate.

When the pop-up is created by a script I pass the current Record ID to that script and go to that

record on the layout in that pop-up (which is a TO of the underlying doc table) so that the list shows those publishers not assigned to the current document.

The calc fields in the doc TO are related to regular index fields in either the author or publisher TOs.

I'm completely stumped. Wny this doesn't work consistently. I have a similar setup with a Keyword table and it works fine.

TIA.

doc_example.pdf

[Ender]

Yo Dude!

It's hard to say for sure without having access to the file, but my guess is that it's a refresh issue. We discovered this problem here when doing this type of exception filtering:

http://fmforums.com/forum/showtopic.php?tid/128500/

In that case, the solution was to use a Refresh Window [Flush Cached Join Results] script step. We also noted that the <> relationships didn't work well for this. We had better luck building a parent key of all the items that are not in the list of selected items. You might read up on this and let us know if it sounds like the problem.

[MuonDude]

Ender -

thanks for the pointer...

I'm not sure what the real problem might have been. One thing I did do is pass the RecordID from the button to the script that creates the Pop-up and join entry (between say a doc and author). In the script I goto record by Calc and enter the RecordID

that was passed in. I took that out and also put the pop-up back to the underlying Doc TO, and just passed the current doc id (serial key). Fixed the overall TOG and both the author picker and publisher picker seem to be working with filtering.

I can't post the whole solution, but I will take some time over the next few week to separate this out into an example file and post that in the hope that other can benefit, and as always suggest where it might be improved.

regards,

-- Sam