Thanx for the responses.

I will need to check for multiple records, so I figure I'll have to use a loop somewhere. I'm used to VB/VBA syntax, but...

quote:

---

NO only the columns you specifiy get changed

Thank you, that's what I thought, but I just wanted to verify it.

Simon Sabin

Co-author of...

quote:

---

When doing an Update, you do have to do a set value for each column

So if I specify only 4 of the...

I don't quite understand the line

set myfield = i.myfield

I would like to insert the record in it's entirety from inserted to DATABASE_02. Do I need to set myfield for...