>Hi Ed,
>
>>Yes it is part of the database, I did put the default statement in and for some reason it didn't populate the table cID for me. Thanks for the suggestion! Paul Mrozowski also repied and I was able to populate the table with the cID values using his suggestion.
>
>Thats good. I see now you said 'exisiting table', oops. What my method does is every time a new record is added the cID is filled in automatically.

That's what NewID() does in the Mere Mortals framework, also.