Self-Join Relationship for finding Duplicate Value with "OR" condition

[dav1089]

Hello,

I have two tables: Companies and dupcheck_companies...Self-joined with Companies:company = dupcheck_companies::company AND Companies:pk != dupcheck_companies::pk

And attached script trigger with layout (onrecordcommit) to show custom dialog if  duplicate key (serial of table occurrence not empty) is found .. it works fine when duplicate company name value is found , but what if I want to check another field (phone number) for duplicates , I think it would be better if I could self-join with an OR condition instead of AND , but don't know how

 

Please help!

 

[comment]

An OR relationship is achieved by using a multi-key field - i.e. a match field that contains more than one value, each on a separate line.

 

 

Edited February 12, 2016 by comment

[dav1089]

And how do I achieve that? Do I need to make Calculation field ? What do I put in as calculation?

 

[comment]

Yes, use a calculation field (result is Text) =

List ( Company ; PhoneNumber )

 

[dav1089]

Ya.. It worked .. Thank you