6. And here is when I have the big problem. Start Project (F5) and add row but is 79 not 78.
That's how it is supposed to be. The field in Access presumbly is an autonumber... that's how autonumbers work! Just because a row got deleted, doesn't mean its ID will get reused... what happens when you deleted #12 ... it doesn't get reused... it moves on to the next one in the sequence. This is by design. It's this way to prevent problems down the road should there be orphaned child records or other related data that still has the old deleted ID in it.

-tg