Duplicate Record Error

radink

Registered User.
Local time
Today, 09:48
Joined
Dec 21, 2006
Messages
18
I'm trying to make a simple DB that we can enter our time for working on projects.

So far I have a Form with the employees name and the date in it. Then below that is a subform with the project number, name, client name, and hours.

I want to use this whole "sheet" for one days worth of work for 1 employee. New sheets will be used for each day.

When I try to make a new sheet I get an error that it cant change the table because it would be creating a duplicate entry.

How do I solve this?

Also, should it be difficult to be doing what I'm trying to do?
 
This probably means that the prime key of the underlying table is incorrect.

I.e. instead of being a single-field key, it might need to be a multi-field key.

Alternative - underlying code in the form tries to do something to the record prematurely, forcing Access/Jet to update it incompletely, thus causing an inadvertant duplication of keys.
 
I think I got it, thanks!

Here's another problem. When I created a new record and fill out a row in the subform it's fine. However, if I switch to another record, and then back, a new row has been created at the top of the subform. Any ideas what's causing this?

Thanks!!
 

Users who are viewing this thread

Back
Top Bottom