Hi All
I’m struggling to get an EnumList which is filtered.
I have a table
EMail
Dept a@b.com Production b@b.com Production c@b.com Production d@b.com Warehouse e@b.com Warehouse
How do i construct the ValidIf statement to get Production department members to only see members of Production and not Warehouse? (and vice versa!)
I’m looking at SELECT([Email],[Dept]=“the same department as USEREMAIL()”)
All help appreciated! Thanks Gordon
LinkedIn
Twitter
