Results 1 to 3 of 3
  1. #1
    nevets is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2012
    Posts
    5

    Multiple events for a individual

    I am new to Access and am using Access 2003. I am trying to create a database of my clients. I am trying to use a unique identifer for each client (using Client ID with an auto number) and enter the cases I am working on. If a client only has one case I am fine, but most have multiple cases. How can I add multiple cases to the Client ID?

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Set up two tables. One will have all your client data. The second one will contain all the events. Ensure that the second one has a client ID which can be joined to the client table. You will have a one to many relationship between your tables.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    In addition to what Alan has said, if you want to understand the concepts of designing tables and relationships, here are some free videos that may be helpful.


    http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

    http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

    http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

    http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

    http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

    http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

    http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

    http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

    You can go back and watch these as often as you want.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Individual Record Reports
    By ThebigCt in forum Reports
    Replies: 6
    Last Post: 02-15-2012, 07:37 PM
  2. Replies: 3
    Last Post: 01-25-2011, 09:50 AM
  3. Individual Records
    By JanisB in forum Access
    Replies: 1
    Last Post: 05-13-2010, 05:38 AM
  4. Multiple events per location Distance tables
    By flebber in forum Database Design
    Replies: 1
    Last Post: 03-13-2010, 08:48 PM
  5. Transferring Individual Records
    By bazillion in forum Programming
    Replies: 0
    Last Post: 01-25-2008, 12:13 PM

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