Portal Row index corruption issue
Hello,
I have been using FileMaker for something like 25 years but not an expert. I use it for managing a few things just for myself, locally on my MacBook and one of them is my time for billing.
Yesterday... I noticed a portal row was displaying more data than it was supposed to. The relationship is set to only show records that fall between two dates but as you can see from the screenshot it is showing dates past the 2nd May 2026. Other records were not having the same issue with it's related records.
I had never seen this before so I asked our lord AI and it suggested to toggle off the Index on the fields, quit the database, then toggle back on again. And this has worked.
But now of course I am really worried that while I noticed this issue what other issues have gone unnoticed??
Anyone seen this before?
Thanks,
David.