Entering Data

[CancerStick]

I have an employee data form that uses two different tables. All the employee info gets entered by using the form and it goes to the employee info table. On the same form, info is entered for emergency contact info, it is entered into an emergency contact table.

My problem is, both tables are related through an employee ID field. When the employee ID field is entered in the employee info table it does not get entered into the emergency contact table even though there is a relationship built between the two.

What am I doing wrong?

I want the employee id field in the secondary table to be entered automatically once it is entered into the employee info table. Is this possible?

 

[Rich]

Why the separate table for a different type of contact?

 

[CancerStick]

You're right

Why the separate table for a different type of contact?

okay, that was a bad example. I realize that emergency contact info should be on the same table as employee info.

But how would you populate a secondary table's related field (i.e. employee ID) when filling out a form for a primary table when the related field is the primary key (i.e. employee ID)? Do I have to fill out the employee ID field more than once? I thought that the referential integrity option would ensure that the field is automatically filled.

 

[Rich]

Use a bound subform