Re: One to may Or One to One? (350 fields all static)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Iram,

On behalf of everyone (well except Steve), and I am sure I am not speaking
out of turn... Thank you for the kind words!!!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Iram" <Iram@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3F6FBCB0-27A6-4098-9227-AEEFA3BC301C@xxxxxxxxxxxxxxxx
I want you all to know that I am not going to hire Steve for anything after
reading all of your caring responses. I appreciate you guys like you guys
can't believe. I only wish that Microsoft would compensate you guys with
Cruises and vacation trips...
Although I got the continuation of the fields to extend into another table
successfully I am considering changing the table structure in the next
revision. 250+ fields are required to describe one record because each
record
tracks an application (someone applying for a job) that has that many
fields.
Changes will be made to the record over time however I plan on tracking
the
changes with an audit table. I am really familiar with one-to-many tables
and
forms however by using them it will change the look of the data entry form
which needs to stay the same as the paper format that the approvers of the
applications are used to...


Iram/mcp




"John W. Vinson" wrote:

On Sat, 25 Jul 2009 19:15:01 -0700, Iram <Iram@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

Hello.
I am creating a table that requires more than 250 fields (total of about
350
fields). All of these fields are required per record.

As everyone else has said, this table design IS WRONG on its face.

Please post the names and meanings of a few of these fields. I'm all but
certain that you have one or more on-to-many relationships embedded in
each
record. "Fields are expensive, records are cheap"; you may well need to
invest
some time and effort in changing the structure of your tables, but adding
new
fields ad infinitum is absolutely the WRONG way to go, and will get you
in no
end of trouble.
--

John W. Vinson [MVP]



.

Relevant Pages