>If it doesn't update when another table is selected, the cause is probably that the other table is at EOF. This is documented in the help, but quite inconvenient.

That what 'IN' clause is for.