From: JRStern@gte.net (JRStern)
Newsgroups: comp.databases,comp.databases.theory,comp.databases.ms-access
Subject: Re: database design
Message-ID: <3b1e7920.12709214@news.gte.net>
References: <40f6cbfc.0105301140.42e1defc@posting.google.com>
X-Newsreader: Forte Free Agent 1.1/32.230
Lines: 12
X-Trace: /whjskjbVgF6AnnoCLm23dnyBlYTIoVurcrD/sorq6VO65fXcuWfsuzuKi40ckLjSRDjlv3inAGH!49CRQ9yg9/re26t2+yateHVH//ChmmOqi0BarXfcABEbyfkUGBK1NTmizB8zCrVx
X-Complaints-To: abuse@gte.net
X-Abuse-Info: Please be sure to forward a copy of ALL headers
X-Abuse-Info: Otherwise we will be unable to process your complaint properly
NNTP-Posting-Date: Wed, 06 Jun 2001 18:36:36 GMT
Distribution: world
Date: Wed, 06 Jun 2001 18:36:36 GMT


On 30 May 2001 12:40:01 -0700, jfraser@mediaone.net (jim fraser)
wrote:
>Currently we are developing a flat file database with a seperate table
>(over 10,000) for each part (looks just like the paper form). The
>problem is trying to perform a query across all tables. Does anyone
>have any ideas on how to perform a query with this large table count
>or a better database design idea?

May I suggest you hire a pro if you want this to work?

J.