>I was considering using a table and storing the last used number (similiar to the new_id function) but I would have to keep a record for each Project.

I would say thats the best way, I mean, you already have PRG and the Table structure. In fact, the way my NextId works, I woulnd't have to change anything, just pass it a project name instead of a field name.