1 Reply Latest reply on Jan 4, 2017 9:04 AM by philmodjunk

    Create OR Relationship Between Tables


      G'day All,

          Trying to create a relationship with OR instead of AND, is it possible to do so?


      Edit Relationship Box.png




        • 1. Re: Create OR Relationship Between Tables

          Not in the dialog that you show. There's no option there. But a form of "or" based relationships are possible using a value separated list of values in a match field.


          You can define a calculation field (text result) in OSV Contacts as:


          AuthorList =

          List ( Book_author ; work_for_hire )


          Then your relationship can be:

          Status::authorMatch = OSV Contacts::AuthorList


          You can probably come up with a better field name than the one I've used here for this calculation field.

          1 of 1 people found this helpful