>Identity fields work just fine... One needs to understand how tha animal works. One cannot stop at ones interpretation of how he/she *thinks* they work...

I am sure they work fine... as a matter of fact, you will see that I sent Ken a solution to his problem... I like identity fields... But there are times when other methods are better... remember, use the correct tool for the job.

>Also, it appears this person is using SPT, not the view designer...

Er, threads drift.

>Right...view designer issues...lets think outside the Fox box here...<s>

Well, we are in the Fox box when we talk about whether to use Remote Views or SPT aren't we? Obviously if we were in VB it would be a different question.

You have been preaching DON'T USE REMOTE VIEWS...THEY ARE THE DEVIL... and, every reason I have heard (From you and Rod) to not use them has been generally a problem or issue with the VIEW DESIGNER!

So, are you preaching don't use Remote Views because the View Designer has some short commings? Shouldn't you be saying DONT USE THE VIEW DESIGNER??? You wouldn't be the first to say that.

And, not to knock SPT, but Views for CRUD forms and SPT for validation... is my preference. Of course, I work on a project where we are supporting LOCAL and REMOTE data... if I was purely SQL Server, I might use a different technique.

Anyway... how did we get on this thread... Ken has his solution.

BOb