>I cannot recall the SQL syntax for updating the values in one table with values from another. I
>have a customer table. I want to populate the average payment age with values computed from other
>transaction tables. The common field is customer ID.
I think the answer to this is, "you can't". You can set a relation between the tables and do the update that way, or you can do other variations on SCAN/SEEK/REPLACE.
I used to live on Kenduskeag Avenue, by the way, and go to St. Mary's. How's Bangor doing these days? Is the Fox user group still active, or did it close down?