Daniel:

Thanks for your reply.

I believe I understand optimizing queries, but since coming from FoxPro where do I find out more information about creating triggers and stored procedures?

Also, as I've pointed out this is strictly local data. Does that make a difference to my question?

Thanks,

Chuck