Page 3 of 3 FirstFirst 123
Results 31 to 36 of 36
  1. #31
    ellixer is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Nov 2010
    Posts
    35

    Ok, this might be a lil bigger.

  2. #32
    jzwp11 is offline VIP
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    You should not have separate tables for each type of program. Have all programs as records in a table and then link them to the participant as I have shown previously.

    The tblPhases also has a problem in that it lists Phase I, Phase II etc. Having sequentially numbered fields is an example of repeating groups which is not a normalized structure. I'm not sure what these phases represent or to what they are associated with but, a structure along these lines would work:

    tblPhases
    -pkPhaseID primary key, autonumber
    -txtPhaseNumber

    tblPhaseActivity
    -pkPhaseActID primary key, autonumber
    -fkParticipantID ????
    -fkPhaseID foreign key to tblPhases
    -dteStart
    -dteEnd

    Also you would not have have a separate table of discharged participants. One table to hold all participants and then a related table to tell their status as to current or discharged.

  3. #33
    ellixer is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Nov 2010
    Posts
    35
    Ahh yes, i was going off what ive been using for the discharged people. There are only 2 phases, and they just have start and end dates. Do i still put them as you set up? And the programs start and end at different times, do i still set up a table for each different group?

  4. #34
    jzwp11 is offline VIP
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    Since you have more than one phase it constitutes a one-to-many relationship.

  5. #35
    ellixer is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Nov 2010
    Posts
    35
    Ok, did a bit of work.

  6. #36
    jzwp11 is offline VIP
    Windows 7 Access 2007
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    I'm still not clear on what process you are modelling with the database. That helps to understand the relationships.

    Regarding your attachment, many of the relationships are missing. Would it be possible to attach the database itself (with any sensitive data removed, of course)?

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Stop subform from creating record
    By eww in forum Forms
    Replies: 2
    Last Post: 09-16-2010, 02:41 PM
  2. Stop tab from creating next record.
    By tazbergy in forum Forms
    Replies: 1
    Last Post: 09-12-2010, 04:29 PM
  3. Replies: 3
    Last Post: 01-14-2010, 10:42 AM
  4. Replies: 3
    Last Post: 01-14-2010, 08:32 AM
  5. Creating "Edit Record" link in table column
    By joshearl in forum Forms
    Replies: 1
    Last Post: 12-25-2009, 11:17 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums