AnsweredAssumed Answered

Relationship problem

Question asked by MikeWile on Aug 6, 2015
Latest reply on Aug 6, 2015 by MichaelWile

Title

Relationship problem

Post

I have a solution that has 364 matching book codes. On a layout, I defined a relationship where the bookcodes of the PRODUCT and the ELEMENT must match AND the IT_Project_FLAG and Add2Nav fields must match. All 364 records have matching bookcodes. Of the 364 records, 2 have the Add2Nav field set to one. The rest are empty. The PRODUCT::IT_Project_FLAG is NOT set on any records but the 2 records with the Add2Nav fields set to 1 show up anyway. Both bookcode fields are Text and the Add2Nav and IT_Project_FLAG fields are set to number.

Any ideas on why these 2 records are showing up when there is no relationship? Thanks.

Relationship.jpg

Outcomes