Thanks - yes please - if could point me in the right direction.

Thanks both of you.

Jeremy - yes I know, I have a procedure which goes thru each subsequent view (very clumsily) and use sp_RefreshView

but then if I wasn't using SELECT *...

Yes thats perfect! Its annoying the query builder didn't get me to there.

THanks

Excellent replies . Thankyou

OK Thanks - I think I have the update part OK.

But the insert bit -

Another consideration is newly inserted records.  If you want to act on those records then the...

Cheers James very helpful - just one think what is PK?

i.pk = cn.pk?

Thats the primary key for the record? and that join only brings out those in i and joins...

Thanks here too!!

Thanks Mr Junkie - thats perfect. Thanks Adrian fro helping clarify the problem.

Almost -

I want a script to generate the table as I have it here - data too.

That script will then be used on the other dbs in other locations. (Once...

Thanks for the answer -

What I am trying to do is basically populate a lookup table data on multiple dbs in differant locations. (With data I have in a...

Thanks both of you - I found this which seems to do the job -