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.