Re: Problem with adding new records to a table
- From: "[MVP] S.Clark" <steve.clark_NOSPAM@xxxxxxxxxx>
- Date: Thu, 13 Oct 2005 14:54:12 -0400
I'd guess that you've added a Unique index to NoShow based on the EmpID.
--
Steve Clark, Access MVP
http://www.fmsinc.com/consulting
"jojo" <jojo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7A04F8C6-C611-40F6-A893-1C7810ADF68D@xxxxxxxxxxxxxxxx
>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!
.
- Prev by Date: Re: Query not returning expected rows
- Next by Date: Re: Filtering records for a work week.
- Previous by thread: Re: lock violations
- Next by thread: RE: Microsoft Jet SQL Reference
- Index(es):
Relevant Pages
|
