Relationship based on 3 fields - What if blank?

[deego55]

I have a relationship based on 3 fields. The 3rd field is sometimes blank in both tables. Whenever that is the case, it seems the relationship does not work correctly. Is there a way for this relationship to work if a field is sometimes blank?

Edited November 9, 2006 by Guest

[ThatOneGuy]

Yeah, that presents a logical quandary. I got around it by using a calculated field that tests whether the firstField is empty. It's Boolean, producing a Zero if empty and a One otherwise. The relationship then uses the calcField.

I don't know if this will work in your situation, but we might be able to figure something out. What else can you tell us about the situation?