Rudy, is this just in access or in other databases too? Emma ps, thanks everyone, this discussion is really helpful. > >as far as updating a join, this is always a treacherous undertaking > >