Garadin,

Wow, that looks great. Thanks!

GSquared,

Haven't had a chance to try that out on 2005 yet, but will the try block stop executing even if it's an error that would...

Oh thanks!

For 2000 I suppose I could just convert all T-SQL into an nvarchar @sql and do this:

execute @SqlSuccess = sp_executesql @sql

if (@SqlSuccess = 0)

begin

--success code

end

else

begin

--fail...

Thanks, so simple! *wack myself on the head*

Thanks so very much Arun! I'm not used to using sub-tables, very nice to learn from simple examples.

Seth Phelabaum, thanks also. I just wanted the ColD...

Thanks, that outputs, but it embarrasses me to say that I forgot to mention another column in the mix, Column D has ungroupable variances. It can't be grouped.

The code...

Thanks again guys!

Too bad SQL 2000 doesn't have PERSISTED. I created a column, but it only changed pre-existing ones, and not new ones.

As for filling in the...

Thanks! That's fine, my only worry about that, is that when I tested it out the numbers that insert next index after the last used used number. To use...

Correct me, but this is what I understood you to say. Previously there has been no column named 'ID'. Hopefully this wasn't a source of confusion. I probably...

Well, there is way too much to change on other tables, dts, access, website etc to make an int for every other table. I'm sort of stuck, needing the...

Hmmm, can't validate that either. It seems string/text isn't allowed?

Thanks for your patience!

I'm trying the single table / calculated column solution. I made an identical test database to test. I created an integer identity column [ID]...

Thanks again! Great advice. I hope/wish I can have time to do things right.

Gsquared,

Access connects to SQL via linked tables (using OBDC). Access might not...

Thanks again! I'll try one of your suggestions.

Is there a good link you have in mind that talks about a sequence table? Or is it almost anything google...

Thanks, at this point no more than one user will add a new record... but as you well know that's not future proof and not safe against non-normal circumstances. ...

Thanks, yeah, an int would definitely be nicer. I inherited this setup. This text/number is even the record ID. The user who made a new record manually...