Can anyone help with the following with regards to setting criteria for a view.
The following statement works fine and restricts the view to show only records where field "Load_ID.Status" is null and also where field "Status" is null...
show all rows from Create_Pallets [(Load_ID.Status is null) && (Status is null)]
I need to add another criteria to further restrict the view to show only records where, in addition to the above, field "Client.Company" contains either "word_a" or "word_b"
I've tried the following but the statement fails...
show all rows from Create_Pallets [(Load_ID.Status is null) && (Status is null) && (Client.Company == "word_a" or "word_b")]
Any ideas would be greatly appreciated.
Thanks.