Right, right. I'm going to try Ed's suggestion of storing the next number in the parent table. I working on it now.

Thanks for the help.

>If it is possible for two users to mofify or add jobs you will have to do the same as a PK to insure that two users don't add the same number or lock out the project if someone is editing it...
>
>
>
>>>If this is single user
>>
>>It's not.
>>
>>>just find the largest number and add one to it...
>>
>>I had thought about doing that, I'm just nervous it might break. They will be added in order and I thinking I could use a p view, go bottom and grab the last number.