Helen,

The emails didn't arrive for several hours and then they were out of
sequence.

I have 3 tables. Two are master/detail and the other is a lookup. If I add
data to the lookup table then the column in the detail table cannot see this
new record unless I close/open the queries again.

I did send an email with my transaction settings etc but so far that email
has gone astray.

I'm basically asking the best way to handle the situation. I know this has
something to do with transactions (my Isolation setting is currently "read
committed")

Does this make sense now or should I start a new thread and start again.

Mal