Ok. So I’m still having trouble writing this security filter for my tables.
**Order Table (Key Column: [Order ID]
- Reference Table:
- Delivery Table [Order ID]
- Order Detail Table [Order ID] [Product ID]
— Product Table [Product ID]
- Render Payment Table [Order ID]
Separate [AOD Table] which has all users info:
- Salesperson ID Column, Email Column
All tables except [Product Table] have the [Order ID], Product ID is the connection for that sub table.
Need help writing the security filters to only pull the reference tables needed that apply to unfiltered Orders in [Order Table].
My current security filter in my [Orders Table]
AND( ([Order Date] >= (TODAY() - 10)), ISNOTBLANK( INTERSECT( LIST( [Salesperson], [SplitSale] ), SELECT( AOD[Salesperson ID], (USEREMAIL() = [Email]) ) ) ) )
So the question is, how do I only have it pull the reference tables needed for each user with Orders they have access. And allow Orders in open status to always show all references applied, but all other statuses will be filtered out as shown above. I’m assuming I would need to modify my current [Order Table] security filter too