Simple OR relationship

[the_kid]

Okay, this has me buffaloed. I thought I knew how to do an "or" relationship, but I just can't seem to get it to work.

I have two tables. Client has a "To" field and a "From" field. Event just has a "Client_Name" field.

I'd like to create a relationship between the two tables that will show all records related to the Client table in a portal in the Event table. The problem is the client name could be in the "To" Field or the "From" field (but not both).

I've tried making a field in the Client table that has both names (To_From field calculation = To & "¶" & From) and joining it to the Event table. I've attached a sample file.

Any help is greatly appreciated (by my face and the keyboard).

test.zip

[comment]

Make the calculation result Text.

[the_kid]

Thank you Comment! I knew there was something I was missing...

My head and keyboard thank you!

/facedesk