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

    Create OR Relationship Between Tables

    bmenendez

      G'day All,

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

       

      Edit Relationship Box.png

       

      Thanks,

      Brad

        • 1. Re: Create OR Relationship Between Tables
          philmodjunk

          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