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!

 

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, 20169 yr by comment

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

 

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

List ( Company ; PhoneNumber )

 

Ya.. It worked .. Thank you