i'll bow out of this thread now. if i'd seen the other thread with your post
earlier, i wouldn't have posted to this one. sure wish people would quit
abandoning threads and starting new ones within a few hours like this.
sigh


"Ken Snell" wrote in message
...
Joe -

In our other thread in m.p.a.tablesdbdesign, I did not say you should not
have a primary key in timecards table. Please read my reply again.

You are not giving people enough information about how your form is set up
based on the tables. Are you using a table structure similar to what I
suggested as a starting point?

--
Ken Snell
MS ACCESS MVP

"joe" wrote in message
...
How can i get the results of each timecard entry to only appear in the
employee table under the employee number which is unique.It is a one to
many(one employee to many timecards) but i just want the entrys to be
under
the one time entry of the employee number not for each timecard and
employee
number to be repeated over and over again in the employee table.I have
been
told to create the employee number as a primary in the employee table and
not to have a primary key at all in the timecard table but when i transfer
all the fields to a form...i get dups not allowed and i cant enter another
record on the form.What am i doing wrong?????? I am unsure if this is a
forms problem or a design problem with the primary key????