Path: csiph.com!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail
From: "Farnsworth" <nospam@nospam.com>
Newsgroups: comp.lang.basic.visual.misc
Subject: Re: VBA code to dynamically create an SQL query for Access db
Date: Wed, 18 Jul 2012 15:03:13 -0400
Organization: Aioe.org NNTP Server
Lines: 19
Message-ID: <ju71a2$g2e$1@speranza.aioe.org>
References: <1e0600a4-e7ef-4eff-9001-45c41482ec1b@googlegroups.com> <ju6hrm$7pt$2@speranza.aioe.org> <141ae15f-9c79-44e1-bfef-d894b1f96715@googlegroups.com> <d2rd08p72cqps5ilngj46j74n91jltgktr@4ax.com>
NNTP-Posting-Host: 2zkn8lvDl69X1tm9Wtth7A.user.speranza.aioe.org
X-Complaints-To: abuse@aioe.org
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-Notice: Filtered by postfilter v. 0.8.2
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-Priority: 3
X-MSMail-Priority: Normal
Xref: csiph.com comp.lang.basic.visual.misc:1374

"ralph" <nt_consulting64@yahoo.com> wrote in message 
news:d2rd08p72cqps5ilngj46j74n91jltgktr@4ax.com...
> One of the first rules of database design is to keep Data separate
> from Presentation. (Actually there are so many "first rules" in
> design, not sure if this is THE first rule or not, but certainly
> deserves honorable mention. <g>)
>
> The second you decided to design a table to be a 'view', you were in
> trouble. Logically store and normalize your data - then write Views as
> needed.
>
> -ralph

I agree with Ralph. Here is a link to show what database normalization means 
in case you weren't familiar with it:

http://en.wikipedia.org/wiki/Database_normalization