I have a medical database which I am moving to FM 7 by reconstructing the database and importing the records. I have a main page that holds patient data with a portal to a related table of prescriptions. I have a button which will take me to the related prescriptions. In FM6, I then can constrain find to find only todays prescriptions. In FM7, it says it finds eg 3 prescriptions, but still displays all the prescriptions for this person. I had to "show omitted" twice to get the right display. Any one else have this experience?

Mgessex:

Welcome to the Forums.

I don't understand. You sound like you're showing the correct number in the found set, but displaying all the records for (what I must assume is) the related record? And then you "Show Omitted" twice, and you end up with the "correct" found set? But showing omitted twice should return you back to where you began. Is this the rabbit hole?

If this is a migration issue, I don't know it. I wonder what you mean by "it says it finds eg 3 prescriptions, but still displays all the prescriptions for this person." How are you displaying the information?

I wonder if this is not an issue with portals...

-Stanley

It sounds like a portal refresh issue. Have you tried adding a Commit Record/Request step at the end of your script? Does using a Go to Record/Request/Page [Next] followed by Go to Record/Request/Page [Previous], instead of the Show Omitted steps, produce the same result?