German Terrazas wrote:

> 10,000 details by 1000 masters = 10,000,000 records in only one
> table.

So - Whats the problem?

Add 10,000 per detail and there is still not a problem.

One of my customers ADDS 4 to 5 hundred orders per day with
an average of 10 line items per order. 2 million records per
year, and now has three years worth. No problem with speed.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services