Create relationship between 2 fields on the same custom table

Nic Omaha
Tera Guru

Hello I am having a hard time wrapping my brain around this one. We have a custom table with 2 fields we would like to compare. 

Order Number and Original Order Number

 

We would like a related list that shows the following:

If Order Number and Original Order Number Match OR  If Order Number and Order Number match

 

Any help is appreciated! 

Nic

5 REPLIES 5

Can you try

current.addQuery('u_order_number', parent.u_order_number+'');


Please mark this response as correct or helpful if it assisted you with your question.