If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#10
|
|||
|
|||
I was told "Fields are expensive, records are cheap"
Rick Brandt wrote in
: When table modifications call for lots of new fields it often means that a one-to-many relationship that ought to be set up in multiple tables is being shoe-horned into a single table. It also means that you have to alter your front-end forms and reports by adding all the fields, whereas if you're adding records instead, whatever continuous or datasheet form you're using to display those records will just have more records in it, so there is no need to alter then user interface objects. To *me*, that's what the phrase means, that adding fields is more complicated in terms of UI, which, to be frank, is where 90% of our time is spent in the development process (rather than in schema design/changes). -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
Thread Tools | |
Display Modes | |
|
|