Form Problem

  • Thread starter Thread starter Bill Anderson
  • Start date Start date
B

Bill Anderson

I am trying to make a form out or one table that has
several records on each individual. I want to display the
Name, rank, etc on the top of the form and then show all
the entries of another field in the same table and be able
to add additional records that also show on the bottom
part of the form. Should I do a subform or do I need to
split the table up into two tables?
 
Hi Bill,

I think you answered your own question. What you have is a "1 to Many"
relationship between Individuals (the one) and whatever else it is that have
many records for the one individual. Once you've split the table you can
create a main form for the Individual and a linked subform for the other
data. This is basic normalization - you really should work towards
normalizing your data before you get too far with UI design.

Here are some articles/links that might help you:

ACC2002: Database Normalization Basics
http://support.microsoft.com/?id=283878

ACC2000: "Understanding Relational Database Design" Document Available in
Download Center
http://support.microsoft.com/?id=234208

Database Normalization Tips by Luke Chung
http://www.fmsinc.com/tpapers/genaccess/databasenorm.html

Database Design Tips - Michael J. Hernandez
http://www.datatexcg.com/Downloads/DatabaseDesignTips1997.pdf

Also check this page for links to several articles and a presentation on
Normalization basics:

Support WebCast: Database Normalization Basics
http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wc060600/wcblurb060600.asp

There are also several books which have good discussions about logical
design and database normalization - two that I like are:

a.. Hernandez, Michael. Database Design for Mere Mortals 2nd Edition. :
Addison-Wesley Developers Press, March 2003

b.. Riordan, Rebecca. Designing Relational Database Systems
 
Back
Top