portal with OR relationship?
I have a two tables where I'd like to create a relationship that finds related records by looking in multiple columns. So for instance, in Table 1 I'd have a field value. It would then look for that field value in the related table (Table 2), but looking in multiple columns for that field value - not just one.
I've tried creating multiple occurences of Table 2, but to no avail.