Transaction question

[roadrunnr70]

Hypothetical queston:
I have a banking application where I need to keep track of last 10 transactions (10 most recent transactions) for an account. So, basically, when the 11th transaction comes in for an account, I need to drop the first transaction from the list of transactions. Can anyone suggest a way to hold this list of transactions?
Please elaborate.
Thanks

[Silmaril8n]

I would probably just select the last 10 transactions and ignore the older stuff. There doesn't seem to be a need to just delete them.