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.
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!