Constraints

[rocky1967]

I am trying to enforce a column constraint on the primary key in a table. I want the first number entered to be 100001.
I have enforced a constraint so taht no number less than this can be entered,[OrderID]>=+100001.
But this is not what i am trying to achieve.
Any help will be greatly appreciated thanks.

 

[Bastien]

just set it through some code...or use the autonumber ( you can set the start number)

hth Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[rocky1967]

Thanks, but I forgot to mention that an autonumber is not an option for this particular table.

 

[Bastien]

set it manually for the first record, then do a quick query to get the last number and then add one to the last number Bastien

There are many ways to skin this cat,
but it still tastes like chicken