>>FROM should be after SET. Don't you know UPDATE syntax?
>
>I never used a FROM clause in the UPDATE command before.

i'm too but its magic :)

	Update Customer;
		SET ;
		Debit = CrsCurrent.Debit, ;
		Credit = CrsCurrent.Credit ,;
		Balance = CrsCurrent.Balance ;
		From CrsCurrent ;
		where CrsCurrent.custID = Customer.custID

(lol)