Jump to content

Creating an OR relationship


Recommended Posts

Hi,

 

I have Client Table and Certifications table, I have already a relationship between the 2 tables based based on Company name.

Some Companies have another name, so i'd to make a relationship also if Company name on the Certifications table also matches Company name2 of the Client table.

Is this possible?

 

Thanks

 

Link to post
Share on other sites

It is possible if you define a calculation field in the Clients table =

List ( CompanyName ; CompanyName2 )

and use it as the match field for the relationship. 

Alternatively, you could make the CompanyName field a repeating field with 2 (or more) repetitions. This too would create an OR relationship when used as the match field.

Is this a good solution? I am not sure. Ideally, a relationship is based on matching a value that is unique (in the parent table) and permanent.  A name does not necessarily meet either of these criteria.

 

Link to post
Share on other sites

Perfect thanks!

The Calculation filed works a treat.

Yes I know making a relationship this way is not the best, unfortunately we get a lot of this data is from a CSV import and the only way to match anything is by the Company Name!

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.