Automatically transfering records from one table to another

[tanhus]

Hopefully someone can help me out. Im making a time card database for my
employees. Every time I add an employee to my database an automatic number is
given to that employee, then i have to go into my time card table and add
that number (employee), so that the individual can fill out there time sheet.
Now im trying to figure how i can automaticaly have a record filled out in
the time card table everytime i add a new employee.
Thanks for those who can help.

 

[Douglas J Steele]

I'd question your design.

There should be no need to add the row to your Time Card table until you're
actually filling in a time sheet.

What do your tables look like?

 

[tanhus]

Well one table holds the employees so it has
Field Name Data Type
Team Member ID AutoNumber
First Name Text
Last Name Text
Position Text

The Time Card table holds:
Team Member ID Number

 

[Douglas J Steele]

What else is in Time Card?

Hopefully you haven't done something like have fields for StartMonday,
EndMonday, StartTuesday, EndTuesday and so on.

Simply create a form that's based on Time Card. For the Team Member ID
field, rather than a text box put a combo box that's bound to the field, but
gets its rowsource from the Employee table. That way, you select which
employee, and get the Team Member ID value to insert into the Time Card
table when you need it.

 

[tanhus]

Yeah I have done that, but I wanted to know if there was a way that the Team
Member ID can be automatically inserted into the Time Card table when someone
adds a new Employee.

 

[Douglas J Steele]

But why? In my opinion, it's a mistake to insert "place holders" in tables.
Add a record for the person when you need it, not just because the person's
been added.

 

[tanhus]

I wanna figure this out, so that the team members do not need to insert there
own time cards and that no one forgets to put a new record into the time card