Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Duplicate Value Question

Status
Not open for further replies.
Pirates

Pirates

MIS
Apr 28, 2002
3
US
I have two combobox(fields) Period and Year
I want to keep any duplicate combinations out of my tblResults table. I do not want the same employee to have 2 entries for March 2002, etc.. My relationship from my tblEmplyees is EmployeeID and my primary key in the tblResults is ResultCount. I think I need a dlookup, but I'm not quite sure how to write using criteria in two fields..
Would appreciate any help.....
 
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question
Duplicate Records in DataSheet View
Replies
5
Views
525
Andrzejek
Andrzejek
BJZeak
  • Locked
  • Question
Struggling with finding an answer to a simple question
Replies
5
Views
529
BJZeak
BJZeak
TrekBiker
  • Locked
  • Question
Duplicate Customers 1
Replies
6
Views
363
Andrzejek
Andrzejek
TinaS
  • Locked
  • Question
Quick one I think - question about Properties window in Form Design view
Replies
1
Views
229
dhookom
dhookom
applestoapples
  • Locked
  • Question
Create duplicate rows based on Qty field
Replies
7
Views
239
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top