I'm having unexpected results from using a calculated field to define a relationship. I have a list of ~ 2,600 part masters but not all of them are active parts, and while I don't want to delete these records I don't want them to appear anywhere in my forms. I thought the right way of handling this was to create a calculated field defined as such;
Then in my relationships I created the following;
When I created my layout I set it up as follows;
I expected to see approximately 200 records however I see all 2,600. I don't know what I'm doing wrong but I can almost guarantee its something stupid. Any suggestions what to check? I even made sure my calculation was returning a text calculation.