These emails all arrived in the wrong order.

My current problem is records added to the lookup table are not available in
the details table unless I close/open the queries. I'm asking for the best
approach to handling this.

Malcolm