Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2006
    Posts
    559

    Unanswered: Normalizing...See any issues???

    Ok, so I'm starting from scratch *again*. Was wondering if anyone sees any issues with the db that's attached as far as structure or whatnot?

    The only thing that I've done is create the tables and add the fields and their types. Although they are not documented or set, it's the way that I'm trying to get them to go.

    The only thing that I don't think I have to do is add "Inspector" or "Agent" to the tblIndividual (main table) if I want some of those fields to show on the form, correct?

    Please let me know.
    Attached Files Attached Files

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    No responses?

    City, State and Zip code are related and should be in their own table.
    Supervisor Firstname, Surname and Phone are related and should be in their own table.

    Document_1, Document_2, Document_3, Document_4. Always a dead giveaway that you have relationship problems when you have the same field with numbers like that. Documents should be a table and related to Individual.

    No need for a Gender table; its contents are static. Could be the same for PosNeg.

    Some of the fields I can't interpret and I don't know what the aims of the database are, so it's kinda hard to say much more.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Aug 2006
    Posts
    559
    Trek,

    Thanks for being the first response. I'll seperate the fields, as you stated above but I guess that's what I got confused about. I figured that since they all pertained to that specific individual, then they would have to be in the same table. Could you explain how they'd relate then if I needed them to show up in a form for just that one particular individual?

    Also, the document fields are areas where the user will be able to scan documents that pertain to that specific individual in the database. Say like a copy of a Driver's license, social security card, visa document, or other papers, even other pictures of the individual.

    Also, the user will have to choose the gender and pos/neg on the main form, where they enter the information on "tblIndividual".

    I'll try to upload a form I designed on a non-working db of this so it'll give you a little better idea on what I'll have to enter on the main form. Hopefully it'll help with what I'm trying to accomplish.

    I'm working on a blackberry right now so it's a little difficult. It should be up tomorrow though.

    Once again, thanks for the help.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Could you explain how they'd relate
    They relate in the way all tables relate. You have a primary key on the "1 side" and a foreign key that matches it on the "many side" of the relationship.

    if I needed them to show up in a form
    In a form you just join both tables together to get the individual and the related content.

    Also, the document fields are areas where...
    The reasoning you put behind them doesn't make the design right. You can rationalise all you like, but it's still wrong

    the user will have to choose the gender and pos/neg on the main form
    You still don't need tables for constant choices. You can have one field in a table and make a combo box or whatever from choices you provide. No relationships are required for that.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •