- I have a security filter set up in all my tables IN( [Company] , App Users[Company] )
- Has multiple Companies
- [Company] is ref column with [Types] as one of the columns. This table has orders for all the companies.
When a user adds a record to the Orders Table, I want to assign a limit to to each [Type] their Company has. Once they reach the limit it only lets them Edit/Delete. Can I do this? Can I put a limit on each Type based on Company