(I didn't want to write in the thread because this is tangential)
> You may not be able to append an autonumber to a SQL server autonumber field though.
Yes you can, using SET IDENTITY_INSERT ON
Hi Crystal, I've mucked this up. I forgot there was no data in it. I was waiting until I got things right but thats no excuse. I'll put some sample data in it and re post it tomorrow. That's the best I can do.
