Hi Barbara,
Talk about Frustrated....yes, that's what I'm doing and I get a 'Operator/operand type mismatch'. Doesn't make sense to me. The first is a Character, 10 length, the second is a Number, 2 length. Does the Index have anything to do with how a view works? These tables are both indexed on a different field, a Character.