Hi Hilmar,
Thanks for your reply.
You mentioned using views instead of tables. Currently, I do not do this. Your example is very similar to my situation. The employee
table is related to the child claim table which has thousands of records. My reports seem to go pretty good, it is mostly the data entry
forms, saving data, and viewing data which is sluggish (which is most of the system).
I will start reading up on VIEWS today and learn more about them.
Thanks again.
Fred
"Sometimes, the agony of not knowing can be more cruel than the truth" - The Fatman Detective Agency