Cool, that should work perfectly. Thanks, Ed.
>Since it's being done so that you autoincrement within the Project, how about adding an nNextJobID field to the project record, setting it to 1 when you first create the Project, and when adding a job for the project, using that as the basis for the number, incrementing the nNextJobID each time you add a new job to the project?
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!