To Avoid Duplicate Entries in 2 different columns in Access Table / Qurey

[nizam]

Dear Friend,


Kindly advise me that is it possible to set the Access Query / Table inoder to that, " Column A" and "Column B" should not allow for duplicate entry.

Not in the same column (Indexed).

I need the buid like the datas i am entering in Filed A should not be the same as the Data entering in the Field B.

If possible for this please advise me

Thanks in advance

[orange]

Make a UNIQUE INDEX on fields FieldA and FieldB.
This would be a composite index that is Unique and Do Not Allow Nulls.

See this for an example
http://www.geeksengine.com/article/c...ex-access.html

[nizam]

Dear Thanks for the reply,
But i need to avoid the duplication of entries in different columns in the same table..?
how to avoid this ?
plz reply

[nizam]

Dear Thanks for the reply,
But i need to avoid the duplication of entries in different columns in the same table..?
Means if the values/data are available in the Column A and same Values / data should not come in the column B when entering datas in column B.


how to avoid this ?
plz reply

[June7]

This could be done by data validation on a form. If you are entering data directly into table, cannot control this.

[nizam]

I am entering through a qurey from that table.

[June7]

Query same as table. Cannot code behind query. However, can set ValidationRule and ValidationText properties in a table. But doubt they will be able to handle validation based on value in another field. Seems I have tried that. Will most likely need to build form and use VBA for validation.

Are you the only user of this db? Developers do not build projects that allow users to interact with tables and queries.

[nizam]

I am the only user for this DB. i developed this one for controlling my project activities.
why this is importanat to me is that, i need the enter the report numbers of some testing we are doing for our job.
So for these tests, the report numbers for each test should be unique, ( For Eg:- For "Activity 1" if test 1 is not accepted, test 2 have to perorm, or test 3,)
for this one i need this

[June7]

Info does not alter our comments.

Custom unique identifier common topic. Review this one https://www.accessforums.net/access/...ber-20506.html