Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Basic Table Structures (97 Sr2)

    Is there anyone out there who would be willing to look at the base table structure for a database I am creating and tell me if I am on the right track? I am very inexperienced in Access, and this is one of my first databases. I understand that if I don't set my tables up properly, then the whole thing will be a mess to fix later. It's not big... I only have 5 tables, and no data yet.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Basic Table Structures (97 Sr2)

    Why don't you attach the zipped database with the empty tables in it. Then anyone who's interested can take a look and give you some feedback here. Otherwise, the information you get won't help anyone else who may be trying to do something similar.
    Charlotte

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Basic Table Structures (97 Sr2)

    Here is the file. My boss gave me the directions that we are setting up a check out system for checking out ID badges for people to access a secure area in our company. He gave me the information he wanted to have included, and I used that to create the table fields. My concern is whether I have normalized the tables properly and set up relationships. Data entry will be done on a form.
    Attached Files Attached Files

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Basic Table Structures (97 Sr2)

    Melanie,

    I looked at your db and would suggest the following:

    tbl_Company Info
    Change the field Company Name to text instead of autonumber. You can add a field called something like "CompanyID" as an autonumber to handle the names as they grow.
    I would make the change to the field in tbl_Personal Info and make it text.
    tbl_Personal Info would only need one field for company name -- probably just "Company Name " and not "Company #".
    It seems to me it may be of some use to relate the tbl_Log to the tbl_TagInfo to indicate who gave out the tag. Adding UserID to the tbl_Tag Info would help.(And relating it to tbl_Log).

    Hope this helps.

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Basic Table Structures (97 Sr2)

    That's exactly the kind of help I needed. Thanks. I'll make those changes.

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Basic Table Structures (97 Sr2)

    Ok. I made the changes suggested. I have done something wrong, though, because I can't data enter a new record in the Key Log table. Something about the joins being wrong. I zipped it and attached it. Would someone please look at this and give me an idea as to what I've done wrong. I create a form and can't enter the key number. So, I checked the table properties, and they look fine to me. The message, though, whether I enter info into the form or table, says something about the join being wrong.
    Attached Files Attached Files

Posting Permissions

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