Thanks Helen and Adam,

Its probably just my DBase + BDE background that makes me shy away
from the exists query to the orders table. I'll write a trigger like
you suggested.

From experience I know the old BDE queries against DBase tables can
take a long time, but its difficult for me to test a fully loaded
trigger like this on my laptop test environment.

Thanks,

Rick