If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding a Subform to An Existing Form
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. J. -- JWeaver |
Thread Tools | |
Display Modes | |
|
|