J
JWeaver
I have a Form that is based on a Table that currently contains a lot of
information that repeats in different records. I want to split this Table
into multiple Tables so that one Table contains just the information
pertaining to each employee (i.e., ID, Last Name, First Name, Emp #, and Pay
Rate) and another Table to gather the payroll specific information (i.e.,
Payroll Date, From Date, To Date, Hours, Miles, and Mileage Rate). I would
like the information in the second table to become a Subform in the Form I
already have.
How can I split this table into 2 tables without losing anything regarding
which payroll data pertains to which employee?
Is it possible to change the Form I have so that a Subform can be added with
all of the payroll information for a particular employee?
Any help you can give me would be appreciated.
information that repeats in different records. I want to split this Table
into multiple Tables so that one Table contains just the information
pertaining to each employee (i.e., ID, Last Name, First Name, Emp #, and Pay
Rate) and another Table to gather the payroll specific information (i.e.,
Payroll Date, From Date, To Date, Hours, Miles, and Mileage Rate). I would
like the information in the second table to become a Subform in the Form I
already have.
How can I split this table into 2 tables without losing anything regarding
which payroll data pertains to which employee?
Is it possible to change the Form I have so that a Subform can be added with
all of the payroll information for a particular employee?
Any help you can give me would be appreciated.