AnsweredAssumed Answered

Unexpected relationship match depending upon field storage type

Question asked by nexgen on May 12, 2018
Latest reply on May 13, 2018 by nexgen

I'm pulling my hair out trying to figure out what's going on. I have attached a sample filemaker file demonstrating the problem.

 

 

Image%202018-05-12%20at%206.49.22%20PM.png

 

These are the fields I have defined in related table:

Image%202018-05-12%20at%206.56.04%20PM.png

Here is the relationship graph:

Image%202018-05-12%20at%206.57.57%20PM.png

 

What do I need to understand regarding relationships to make it work as I expected and what am I doing wrong?

 

PS: I can't seem to upload images using my computer. I have inserted images by uploading it first to somewhere else and provided the web url. Is the upload image feature not working in this community?

Outcomes