Need help to filter records from condition

[42894]

Hi,

I am using CRXI. I have 2 fields and values of that fields are as below:
A Owners B Owners
-------- ----------
ABC-LMN XYZ-LMN
XYZ-LMN ABC-LMN
DEF-LMN

I need A Owners where name contains *LMN* but if and only if same value(name) is not in B Owners.

I would really appriciate your help.

Thanks in advance
Aataman

 

[lbass]

Use a left join from the A table to the B table on the Owners field, and then use a record selection formula like this:

{A.Owners} like "*LMN*" and
isnull({B.Owners})

This assumes that the field is called Owners, and the tables are A and B.

-LB