Re: 2 subforms linking to a main form

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

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 10/05/04 

Date: Tue, 5 Oct 2004 05:58:53 -0700

A first observation -- change the name of your table named "Name". "Name"
is a reserved word in Access, so you will only confuse both Access and
yourself unless you change it. A common table name for information about
persons is ... Person, or tblPerson.

You may need to go back to the drawing board (no, literally!). Shut off
your computer and grab paper and pencil. Your data structure may benefit
from a bit more normalization. Designing the underlying data structure is
something you do with paper and pencil, sketching out possible tables and
relationships.

Based on your description, it sounds like you have persons, states and
companies. So far, so good. But you also described what sounds like
relationships involving persons and states, and persons and companies. Your
current design doesn't have any tables to hold these.

For example, if a person can have worked at multiple companies, and the same
company could have multiple persons who had worked there, you have a
many-to-many relationship. You can only resolve this in Access using a
third table, perhaps something like:

    trelPersonCompany
        PersonCompanyID
        PersonID (from the tblPerson)
        CompanyID (from the tblCompany)
        DateEmployed (date person started at company)
        DateLeft (date person left the company)

A similar situation would apply if you have a many-to-many relationship
between persons and states. 

-- 
Good luck
Jeff Boyce
<Access MVP>

Relevant Pages

  • Re: Fun router technique question
    ... I placed a drawing of a pencil holder of something I am ... designing. ... Cut the bottom shelf into three pieces,the pencil slot can be made by making a pattern, from some mdf or ply, then use a straight pattern bit and a router table,rout the shape of the bottom of the pencil tray with the material on it's edge,then rip it to width and edge glue the three pieces together .If the tray is wider than the length of the bit,then make a couple and edge glue them together. ...
    (rec.woodworking)
  • Re: Which tools to use for early design stage of a programming project?
    ... Your best and most flexible design tool is a pencil and a sheet of paper. ... It's interesting that books say that planning and designing is the most ...
    (comp.programming)
  • Re: Fun router technique question
    ... designing. ... Cut the bottom shelf into three pieces,the pencil slot can be made by ... pieces together .If the tray is wider than the length of the bit,then ... make a couple and edge glue them together. ...
    (rec.woodworking)
  • Re: How does Sinclair Research keep going?
    ... Just goes to show that being good at puzzles with pencil and paper ... that he's pretty good at "designing for the real world", ... most of that money was from the computer business. ...
    (comp.sys.sinclair)
  • data structure question
    ... What is the best data structure for designing a telephone directory ... WHat is spped of lookup? ...
    (comp.programming)