WHY Analyze Table Wiz gives multi-value fields???

[Guest]

The Analyze Table Wizard is a nice starting place for converting existing
flat databases to multiple related tables. But WHY does it sometimes result
in fields with multiple values???

THANKS!

 

[Guest]

Because it's basically brain dead.

My advice is to use a clean sheet of paper, with a sharp pencil and a good
erasure for redesiging your database. You'll likely be able to do a much
better job than the Table Analyzer wizard. Be aware that this wizard just
loves to create table lookup fields for you. Lookup fields art thy creation
of the evil one.


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Thanks Tom!

Are you saying Lookups are evil in general or just these wiz-spawned ones?
On forms also?

Just curious.

Thanks again!
hasta,
Mike

 

[Guest]

Hi Mike,

Lookup fields defined at the table level (or within a query), whether done
so by a user or a wizard, are evil. Please see the second commandment here:

The Ten Commandments of Access
http://www.mvps.org/access/tencommandments.htm

On forms also?

No. Combo boxes are not a problem on forms. We generally do not use the term
lookups to describe combo boxes on forms. Combo boxes typically use a lookup
table as their row source, but this is not the same as a field level lookup.


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________