Dear Dave
Thanx for ur suggestion. But it will really be helpful if you elaborate a little. I have a database for around 3500 orders, 10 different client having around 1100 components. I've split every entity into different tables with one-to-many relationship with referential integrity...