Software

Ask something
Discussion Locked

Duplicate data entry in Access Database

0 helpful
5 replies

by julia is here

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

5 replies

by mbarker734

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

Good luck,

Mark

by learneverything

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.

This discussion is closed to new replies.