General discussion

Locked

Duplicate data entry in Access Database

By Julia is here ·
I'm having a problem controlling data entry in one of my tables. The table tracks software loaded on PCs. This table has 3 feilds, the 1st is an autonumber key field, the second is the client and the third is the software package.

Each time a client gets software, there will be a new record with the clients name and the software name, but each client can only have one copy of each software package.

How do I set my form so that it will look at the two fields together to determine if there are duplicates?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Duplicate data entry in Access Database

by mbarker734 In reply to Duplicate data entry in A ...

Using a Find Duplicates Query will produce a results query on the fields you select.

Good luck,

Mark

Collapse -

Duplicate data entry in Access Database

by Julia is here In reply to Duplicate data entry in A ...

A Query won't help. Need at table or form level.

Collapse -

Duplicate data entry in Access Database

by learneverything In reply to Duplicate data entry in A ...

In the design view for the table, select the 2 fields you want to have as unique (together) and make them your primary key field. This will prevent dupes in the future.

To get rid of existing dupes, look in Help under eliminating duplicates in atable, there is a specific step by step procedure involving an append query that will fix it.

Good luck.

Collapse -

Duplicate data entry in Access Database

by Julia is here In reply to Duplicate data entry in A ...

Poster rated this answer

Collapse -

Duplicate data entry in Access Database

by Julia is here In reply to Duplicate data entry in A ...

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums