Re: Hours Worked

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ken Snell [MVP] (kthsneisllis9_at_ncoomcastt.renaetl)
Date: 12/06/04 

Date: Mon, 6 Dec 2004 09:09:36 -0500

In tblHoursWorked, are you using ClockNo and Reason as a composite primary
key, or is there no primary key in that table?

The warning about duplicates suggests that you may have these two keys as a
composite primary key, which means that, even though each can accept
duplicates, there cannot be two records where the values of both fields in
combination are the same in both records (e.g., ClockNo value is 1 and
Reason value is 1 in one record, so no other record can have that same
combination).

What is DateWkd in tblHoursWorked table? I don't see a field that has a name
that seems to correspond with "hours worked" that you say you're entering
into this table? 

-- 
        Ken Snell
<MS ACCESS MVP>
"Pete" <pete@nospam.net> wrote in message
news:cp1nte$fi4$1@newsg2.svr.pol.co.uk...
> I wish to keep a track of hours worked by employees, these can be for
> various reasons e.g
>
> Training
> Sickness
> Visits
> Bereavement
> Paternity
>
> I thought a many to many relationship would do, but I am struggling to get
> it to accept duplicate values. Tables I have are:
>
> tblEmployee
> ClockNo (Primary Key)
> Name
> Dept
> Shift
>
> tblHoursWorked
> ClockNo (Foreign Key)
> Reason (Foreign Key)
> DateWkd
> Comments
>
> tblReason
> Reason (Primary Key ) (e.g Training, Sickness etc..)
>
> When I try to assign some hours worked to an employee, If they have
already
> worked some on Training, I get the error about duplicates. Both ClockNo &
> Reason are set to accept Duplicates in tblHoursWorked
>
> Any help would be appreciated
>
> Pete
>
>

Relevant Pages

  • Re: Hours Worked
    ... ClockNo & Reason are the only "Keys" in that table, ... >composite primary key, which means that, even though ... >duplicates, there cannot be two records where the values ...
    (microsoft.public.access.gettingstarted)
  • Re: Hours Worked
    ... Do any of the fields have a Key icon at the left side of the field column at ... > ClockNo & Reason are the only "Keys" in that table, ... >>duplicates, there cannot be two records where the values ...
    (microsoft.public.access.gettingstarted)
  • Re: C64 BASIC question
    ... duplicates. ... tokenized and no spaces are in between most of the commands. ... statement in a multi-statement line. ... It's for that reason that it's not advised to ...
    (comp.sys.cbm)
  • testing
    ... My apologies for posting as a new post but for some reason when I reply to ... so sorry if this duplicates along the way.. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Hello PPl, is there a way of locking a design (NGC) to a particular FPGA board?
    ... no reason to be scared of arguing with me. ... My experience with these 1 wire electronic serial numbers was with Dallas semiconductor parts almost 15 years ago. ... the company I was working for was able to get duplicates made by Dallas. ...
    (comp.arch.fpga)