Robert L. Stewart
rl_stewart at highstream.net
Tue Feb 21 15:08:15 CST 2006
Then it is definately bad design.
tblAccident
AccidentID
AccidentDesc
Etc....
tblAccidentProperty
AccidentPropertyID
AccidentID
PropertyId
AccidentPropertyComments
etc....
tlkpProperty
PropertyID
PropertyDesc
This will allow you to add as many "properties" to an accident as you need to in
a normalized fashion.
Oh, and only one combobox, PropertyID, in it.
Robert
Date: Tue, 21 Feb 2006 06:46:58 -0800
From: "Joe Hecht" <jmhecht at earthlink.net>
Subject: Re: [AccessD] How many cbo atr too many cbo
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Message-ID: <001201c636f5$aafe2e70$6701a8c0 at HPLaptop>
Content-Type: text/plain; charset="us-ascii"
John,
It is about 50 fields all one to one about the same thing.
Accident Properties.
Joe Hecht
jmhecht at earthlink.net
Robert L. Stewart
The Dyson Group International
Software for the Non-profit Enterprise
Expanding your Sphere of Knowledge