I find myself in need of filtering a tab panel, but I want to do it based on one column having one value OR another value (or even another).
Currently, when you define a relationship, each line is AND'ed.
It would be nice to have a way to change the linking of the lines to allow 'OR' as well.
I guess the UI would have to be an extra column in the relationship dialog that defaults to 'AND' but you could change to 'OR' and the OR would be between that line and the next??
(I know that I could work around this by having a numerical values for the column and use globals & >= and <= lines, but I just want to be able to list some text values...)
[To define my example, I have a 'Notes' table related to 'Clients' and there is a column 'note_type' with values like email/phone/post/label and I want to create a relationship like
- Code: Select all
client -> notes
id = client_id
globals.post_text LIKE note_type OR
globals.label_text LIKE note_type
if there is some other way of doing this easily, please let me know ]
Otherwise, would this feature be possible??
Thanks
Rafi