AnsweredAssumed Answered

"Go to related record" does not consider the portal filter, in combination the script trigger...

Question asked by KoenVanHulle on Apr 14, 2011
Latest reply on Aug 12, 2016 by TSGal

Summary

"Go to related record" does not consider the portal filter, in combination the script trigger OnLayoutExit

Product

FileMaker Pro

Version

11v3

Operating system version

Mac Os 10.6.7

Description of the issue

"Go to related record" does not consider the portal filter, in combination the script trigger OnLayoutExit

Steps to reproduce the problem

1. Create a new file
2. Create two tables "dashboard" and "items"
"Dashboard" will have one field "key"
"Items" will have 2 fields "Kind" (Text) and "Item"

3. Make a Cartesion product relationship between both table.

4. Populate both tables
"Dashboard": one record

"Items":
Fruit     Apple
Fruit     Banana
Fruit     Grape
Vegetable     Endive
Vegetable     Tomato

5. Create a new portal on the layout "Dashboard", with data from the Table Items. Add all fields to it.
6. Add a portal filter to the portal: Items::kind = "Fruit"
7. Add a button on the portal row with the script step:
Go to related record[From table: Items; Using layout:Items] with the option: Show only related records, Match current record only.

8. Go to Browse mode: you will see 3 related records in the portal.
9. Click on the button in the portal.
10. You are now on the "Items" layout, and you have a found set of 3 records?

11. Create a new script "TEST", with one script step;
Set Variable[$test; Value:1]

12. Go to the layout "Dashboard" and add the script trigger OnLayoutExit to that layout, making use of the new created script.

13. Click on the button on the portal again.
14. You are now on the "Items" layout again, but you have a found set of all records.

Expected result

I would expect the 3 related (filtered) records.
Notice that there are no script steps like Commit record, are involved.

Actual result

All related records without considering the portal filter

Exact text of any error message(s) that appear

None

Configuration information

None

Workaround

Don't use the script trigger "OnLayoutExit"

Outcomes