Problem with adding new records to a table

[Guest]

I have 2 tables: EMPLOYEE_TBL (employee Id, Employee Name) and NO_SHOW_TBL
(no_show_id, employee_id, no_show_date). Both tables are joined by
employee_id (1 to many relationship). The query is linked to a form where I
want to keep track of all days that the employee calls in. Every time I
enter a new date, a new record should be added to the NO_SHOW_TBL. But the
form will only allow me to enter 1 record (date). Why can’t I enter more than
I record? I appreciate any help anyone can offer!

 

[[MVP] S.Clark]

I'd guess that you've added a Unique index to NoShow based on the EmpID.

 

[Guest]

What do I need to do to add a "Unique index to NoShow based on the EmpID".
There is a primary key in NoShow, but I don't think that's what you are
referring to...

 

[Guest]

Open the NO_SHOW_TBL in design view. Highlight employee_id and
no_show_date then click on the yellow key icon. This makes a two field
combination key.

An alternate to this if you need the no_show_id as a key field is to open
the table in design view and click on the menu VIEW Indezes. Here you can
build a multi-field index and make it unique.