No, that did not work and I've been exploring the 'EXISTS' statement without success either.....

Here's what I have so far. The problem is when I specify 'not in', it returns nothing.....

I have purposely place one unique name in tbl_Reports to test the query..

The query...

That was a typo while posting. It does read "WHERE SalesID = @SalesID";

Here's the update procedure from a Microsoft book that I've been using successfully for the 'Update' and seemingly accurate for the 'Insert'. I know it's not an insert syntax, however...

I did'nt have the 'Catalog' populated...........

" I can only view the column headers in MS Query Analyzer when I run the following code. I have correctly setup the index catalog in MS SQL 2000...

Thanks, I was thinking that MS SQL 2000 Query Analyzer has some limits.