How do I put a limit to the amount of rows a User can enter?

[Sam_Sulkey]

I have:

User Table

• I have a security filter set up in all my tables IN( [Company] , App Users[Company] )

Company Table

• Has multiple Companies

Orders Table

• [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