I'm pulling my hair out trying to figure out what's going on. I have attached a sample filemaker file demonstrating the problem.
These are the fields I have defined in related table:
Here is the relationship graph:
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?