max rows for record in a column

[c3118526]

I have a transaction table where transaction id (primary key), membership#, and dates are kept. I want to make it so that there can be at most 5 transaction id for each membership#

[pulpfiction]

Not sure if you can do that in SQL. You must do that restriction with application...

[nibe49]

Hi RyanaldoIn principle you can use a trigger that fires on a table insert. The trigger would need to carry out some action depending on a count of ids in the table. Triggers are a bit variable in syntax from 1 SQL vendor/product to another so I hesitate to write any code.The question to ask is what you want to do when transaction 6 comes along, you probably should not just ignore it.I think I would agree with pulpfiction that this is better controlled in the calling application.regardsnibe