Hi,

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

Just to add my 2 cents to what the others have mentioned already.

If you have to add a field to all of those detail tables, how would
you proceed, so it is done efficiently?


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)