and(ANY(SELECT(AOD[Salesperson ID], ([Email] = useremail())))=[SalesPerson],[Order Date]>=today()-12)
Above formula works perfect and shows each user all their orders.
However i need it to show their Splitsale too:: So at the end of the day, if the users name pops up in either field as [salesperson] or [splitsale], then i need that user to have access to it.
[Salesperson], [Splitsale] : Both are fields in Orders Table that chooses reps name.
I wrote it several ways but doesnt seem to work. Any ideas