AnsweredAssumed Answered

Unexpected Results from Relationship

Question asked by Razor on Jan 13, 2016
Latest reply on Jan 14, 2016 by Razor

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;

Screen Shot 2016-01-13 at 12.46.40 PM.png

Then in my relationships I created the following;

Screen Shot 2016-01-13 at 12.47.34 PM.png

When I created my layout I set it up as follows;

Screen Shot 2016-01-13 at 12.48.12 PM.png

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.

 

Thanks!

Outcomes