Chris,

We're in danger of drifting away from the original topic here but the answer to your new problem is to use Check Constartaints.

You actually need two pointer fields, one for...

Chris,

I'm just wondering if you may be coming at this from the wrong direction.

I'm not familiar with the book you quote but, from what you say, it would appear that...

Sorry. I was a bit slow on the uptake here.

The answer to my problem is obviously the same advice as the first response to the original query.

Thanks anyway. Bye, Mike.

I have a similar problem EXCEPT that I need to insert a record into a table with an Identity column and I want to create my own identity on the...