Can a table be created from a template table

[fh217]

Hi,

I have an employee job time data entry application that uses 2 tables of
data imported from a mainframe.
The first table is a 'Master' containing the Employee Number (key), Name,
ect. The second table is a
'Job/Time' containing the Employee Number and Job Number as the key, Time,
ect. Each employee has
20 records in the Job/Time table ( each job is an individual record ). What
I would like to do is import just
the 'Master' file from the mainframe and generate the 'Job/Time' table from
a template table in my application.
The template table would have the 20 jobs, and a set of records would be
generated for each employee in the
'Job/Time' table. Would this be possible in a query? Currently the
application does not allow new employees
to be added, I would also need to add a set of records from the 'Job/Time'
template each time a new employee
is added. I appreciate your help and thank you.

 

[fh721]

Hi Ken,

Thank you for your help, it works perfect on the new employee.