Record in relationship not adhering to relationship rules

Questions
1

Hi there, I'm having a weird relationship problem
I've got a relationship set up between the table ASSIGNMENT and Assignment » Exams like so:

Schedule ID = Schedule ID
Quote ID = Quote ID
_One = Header
_One = Tested
Segment = Package Segment

It worked flawlessly for years now, only the tested Exam headers related to that assignment's schedule and quote segment were listed

However today I found an Invoice with a row that should not have been there
It seems the relationship did not filter one of the rows

The thing is, checking the data, everything seems ok
_One is a calculation field that of course has not changed its value from 1 (evaluated as Number)

All the Exam's data matches, except for the tested boolean (also Number)
The Exam is listed within the relationship regardless of me setting the Tested field to 0 or empty!

Any idea what could be the cause?

Listed record not matching relationship
Listed record not matching relationship1168×832 64.4 KB

2

That could be cached data getting in the way. You could force a refresh of the data on the client side. Sometimes wacky indexes are fixed by quitting FileMaker and restarting.

3

It has been reported by one user, and observed by me, so it's not client-sided
Restarting the server itself has also not helped

4

If a backup copy running locally also shows the problem then you need to rebuild the index for that field. If it doesn’t show the problem then it is an issue with cached data.

5

That was it, bad index!
I wonder what causes this

Thank you :slight_smile:

6

I blame photons.

1 Like