Results 1 to 2 of 2
  1. #1
    teza2k06 is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    5

    Question Relationships

    Hi All,
    Can someone look over my database?



    I have created the tables and the main form, im needing someone to sort out my relationships. On the subform of the main form i want it to have the information that is linked with that persons information(when you see it you will understand).

    Also when you double click the form to use it it comes up with "Type mismatch in expression"

    Once it is working properly then i can get it looking bit better and hopefully add some working buttonsdatabase.zip

    -Terry

    database.zip

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I have looked at your tables and relationships briefly.
    I think your tables are suffering from "over thought/over thinking" or attempting to work with a chcklist.
    For example, you area of Interest would be better set up as

    tblAreaofInterest

    AreadId PK
    AreaName text

    The values for AreaName would be the values you have as Yes/No fields.
    You may present values with check boxes on a form, but for table design that Yes/No is not preferred.

    Your Tasks, Outcome and Outcome Of Support are similar.

    For IDs in your tables, it is recommended to add a prefix to ID to help understand what the ID is for. If every table has an ID field, how do you know which table you are dealing with?
    So InterviewID, TaskID etc.

    You will help yourself considerably by not having spaces or special characters in your field names. Use only alpha or numeric and "_" and you will prevent a lot of syntax errors.

    In your interview table

    who is being interviewed? Do you also record who conducted the interview? In a relational database, in the interview table you would not store Outcome, you would store OutComeID. OutComeID in the interview table would be a FK related to the OutComeID PK in the OutcomeTbl.

    You should review Normalization.
    Also here is a tutorial that will help you with your database design -- tables and relationships.
    http://www.rogersaccesslibrary.com/T...lationship.zip

    Good luck.

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

Similar Threads

  1. Relationships VS VBA
    By Cindy morgan in forum Access
    Replies: 1
    Last Post: 11-08-2012, 07:58 PM
  2. Many relationships to one
    By trumpetman in forum Access
    Replies: 3
    Last Post: 06-28-2012, 12:25 PM
  3. Relationships
    By snowboarder234 in forum Database Design
    Replies: 14
    Last Post: 02-29-2012, 04:53 PM
  4. Help with relationships
    By clive2011 in forum Access
    Replies: 5
    Last Post: 09-14-2011, 03:00 PM
  5. Relationships again
    By BarbT in forum Access
    Replies: 2
    Last Post: 11-09-2010, 04:12 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