Thanks...I will try this out when I get back to work, but what happens if I want to extend this sql to reference an ID in the BOOK table rather...

Thanks Karl! That's working great!

Cheers,

Daniel

Hi Paul,

Thanks, I think that's got it!

I just needed to change the left outer join to an inner join to not get the multiple records (?)

Cheers,

Daniel

Hi Paul,

Thanks for the post...The exec() option seems a lot easier....Is there a trade off for doing it that way? also, is a table variable basically an array in asp?

Thanks,

Daniel

Hi,

David (above) mentioned that you don't need to use an 'INSTEAD OF' trigger...Is there no way to do just a simple insert if you want to put foregin keys in...

Thanks for your advice, although now that I've come around to actually write the SQL, I'm a little confused.

My Primary keys are automatically generated by SQL Server...How do I know...

Thats right. A job cannot exist without entering the person record...

So you're basically saying that joining the tables on FK's and doing one insert statement is not possible?