On Wed, 13 Jan 2010 13:25:01 -0800, Jerry Whittle
wrote:
One good rule to follow about database design is to build for easy expansion.
You may only have 4 analysis now and maybe forever, but there's heck to pay
the day someone adds a 5th one. I've learned and relearned this hard lesson
more than once especially after a customer swore that it would never change.
Yes, and even if you're not worried about future expansion (I've been
in this business too long not to worry about it
then you still
should consider that querying 4 different fields in 1 record is always
harder than querying 1 field in 4 records. Databases lend themselves
to sets of records, not sets of fields.
Armen Stein
Microsoft Access MVP
www.JStreetTech.com