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

[Iram]

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

 

[Duane Hookom]

Trying to structure your table to match a paper format is a common mistake.
The paper display should never dictate the actual data storage.

I would consider creating tables like:

tblApplication (one record per application)
appAppID autonumber primary key
appFirstName
appLastName
appRecvdDate
app...

tblAttribute (one record corresponding with previous many fields)
attAttID autonumber primary key
attName values such as "highest education level", "Salary request",...
attActive yes/no

tblAppAttribs (possibly 300+ records for each applicant
apaApAID autonumber primary key
apaAppID links to tblApplication.appAppID
apaAttID links to tblAttribute.attAttID
apaValue values such as "HS Grad", "BS", "GED",...

This solution would allow you to add attributes without changing structures.
There is a similar structure in "At Your Survey"
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3 and Employee
Evaluation http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=15.

 

[Iram]

Thanks Duane!
Your info and links helped me think about my table structure and how I need
to change my approach.



Thanks again.


Iram/mcp

 

[Gina Whipp]

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

 

[Jerry Whittle]

Could be worse. Iram could have been given advice to upgrade to SQL
Server......

 

[Gina Whipp]

....still laughing!

--
Gina Whipp

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

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

 

[Tony Toews [MVP]]

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.

Thanks for your kind words.

I only wish that Microsoft would compensate you guys with
Cruises and vacation trips...

So do we! <smile>

Tony