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.