Serials with a twist

[Agent Shooter]

I have a problem that I know you guys here will help me with (you guys are the best)!.

I'll try to make the problem easy to understand - I have two account types PAY_IN and PAY_OUT. Now what I want is that whenever the record is of type PAY_IN I would like the serial number to increase, but if I add a PAY_OUT the serial number shouldn't change.

Any ideas on how this could be done??

Thanks

Agent Shooter

[TSC]

You can create a seperate file that contains a counter field. When you ad pay in, enter the current count from the other file and increment the number by one