By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,660 Members | 1,939 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,660 IT Pros & Developers. It's quick & easy.

check Duplicate

P: 71
Hello friends, I am stuck with Duplicate problem. So looking for help.

I have a data entry form (name is "Review Entry From") and I want to check 2 field from 2 different tables.

1. Check Drawing and Rev from Process table and if both conditions are Not Ok then message "Drawing with this Rev dose not Exis".

2. Check Drawing and Rev from Reveiw table and if both condition are found OK... the message should be "Drawing with this Rev already exist".

Both checks should be on form.... form name is "Review Entry Form"
Thanks in advance from all friends.
Irshad Ahmed
Jun 25 '12 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,365
Create a unique index on the fields in the tables and you won't have to do any checks. Access will enforce it itself and not allow duplicates to get put into the table.
Jun 25 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.