>So how do I go about using a CA to create a join where only the changed record
>in the left table gets updated?
>

Hi Kevin,

You should make sure that the key fields bound to the table represent a candidate or a primary key for the table.

Thanks,
Aleksey.