Normalizing Tables and Enter Data in Fields Based on Employee Numb

Discussion in 'Microsoft Access Forms' started by JWeaver, May 22, 2008.

  1. JWeaver

    JWeaver Guest

    We had information that was being entered into a spreadsheet that we imported
    into Access through the Import command and let it create the table
    automatically. This table is used to capture weekly work detail information
    for employees (Payroll Table).

    We have another table that has all of the pertinent HR detail regarding
    employees (name, employee #, rate, etc.). This table was also imported from
    Excel. Only updated if new employees are hired.

    After reading some of the discussions concerning normalizations I realize
    that both tables have the same information in them (but with different field
    names) and that the Payroll table should be changed so that the duplicate
    fields are not there but only a reference to their information in the
    Employee Table. Is this correct?

    Employee Table fields:

    Last Name (Text)
    First Name (Text)
    Home Dept (Text)
    Emp (Text) - this is the employee number
    Hire Date (Date/Time)
    Rate (Currency)

    Payroll Table Fields:
    Payroll (Date/Time)
    Employee Last (Text)
    Employee First (Text)
    Emp # (Text)
    Pay Rate (Number) - no calculations are done on this field

    The Payroll Table has other fields but they do not relate to the Employee
    table. How would I normalize my database to make it better?

    I have set up a relation between both tables using the Employee Number.

    I have been trying to figure out a way to have some fields automatically
    fill in based on information that is selected in the employee # field, i.e.,
    first and last names and rate. What is the best way to do this?

    Your help is greatly appreciated.

    --
    JWeaver
     
    JWeaver, May 22, 2008
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    Enter user name, enter password, then press enter...

    Guest, Jul 11, 2005, in forum: Microsoft Access Forms
    Replies:
    6
    Views:
    1,251
    Guest
    Jul 11, 2005
  2. Lisa

    Form/Subform normalizing issue

    Lisa, Oct 31, 2005, in forum: Microsoft Access Forms
    Replies:
    1
    Views:
    143
    Amy Blankenship
    Oct 31, 2005
  3. Guest

    Autofill fields based on Employee name

    Guest, Aug 16, 2006, in forum: Microsoft Access Forms
    Replies:
    0
    Views:
    175
    Guest
    Aug 16, 2006
  4. John Memorex via AccessMonster.com

    Normalizing tables

    John Memorex via AccessMonster.com, Sep 23, 2006, in forum: Microsoft Access Forms
    Replies:
    1
    Views:
    206
    strive4peace
    Sep 23, 2006
  5. CJ
    Replies:
    1
    Views:
    142
    Albert D. Kallal
    Apr 5, 2009
Loading...

Share This Page