Duplicate content ?

[_Chris_]

Hi all, how do you do it, when for example, in a field, you don't want any duplicates, but in the same field you may have 2 values. So for example, in the email field, in one record you have test2@email.com then in another record (still in the email field), you have test1@email.com and as soon as you input for example test2@email.com it tells you you can't do that, as it would create a duplicate. How would you solve that one please?

[Micron]

Don't understand the question. You say you don't want duplicates and the design is not allowing it. Then what's to solve?
We're not talking about multi-value fields here are we?

but in the same field you may have 2 values

They should be avoided.

[_Chris_]

In some records there may be just one email address, and in others, maybe two, the idea is for there not to be a duplicate in any part of the records for that field

[JoeM]

How exactly do you have two email address in the same field?
Are you dealing multi-value fields (like Micron mentioned - see: https://support.office.com/en-us/art...c-6de9bebbec31)
Or is it simply a text field where you have multiple entries in a single string separated by something like a comma, space, colon, etc?
If the latter, what is used to separate the various email addresses?

[ArviLaanemets]

In some records there may be just one email address, and in others, maybe two, the idea is for there not to be a duplicate in any part of the records for that field

What is 'record'? And What are 'parts of record'?

I'll try to quess what you want to do. Do yo have some table of persons/firms, and among other information there is a field for mail address? And in some cases you have several mail addresses for one person/firm?

When this is the case, you need 2 tables, p.e.:
tblPersons: PersonID, FirstName, LastName, ...
tblEMails: EMailID, PersonID, EMailAddress, ... or tblContacts:ContactID, ContactType, Contact (the other variant is for case, you have several different type contacts (phone number, e-mail address, home page address etc), and a person can have several of any of them.
In tblEMails/tblContacts you can have for certain person any number of mail addresses/contacts

[orange]

cross posted at:
https://access-programmers.co.uk/for...37#post1534337

-Chris-
Please give an example from your tables showing the issue clearly.
Readers should not have to guess at what you are having difficulty with.

Read this from excelguru regarding cross posting.