We have a DB where two of the tables HAVE to have the employees ID entered.
Table1 is where the personnel information is kept (Name, DOB, Address,
etc.)
and Table2 is where the equipment that is issued to this person is kept.
When a new employee is hired, the main DB has a button (new employee)
which
opens a small form asking for the name, team assignment and employee ID.
This infor is written to Table1, and the employee needs to be written to
Table2 also.
So far, i have not been able to get this to work.
Can anyone offer some assistance, please?
Thank You.
|
