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 derfloh 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
Joined
Apr 28, 2002
Messages
3
Location
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 Question
Duplicate Records in DataSheet View
Replies
5
Views
1K
Andrzejek
Andrzejek
BJZeak
  • Locked
  • Question Question
Struggling with finding an answer to a simple question
Replies
5
Views
964
BJZeak
BJZeak
TrekBiker
  • Locked
  • Question Question
Duplicate Customers
Replies
6
Views
757
Andrzejek
Andrzejek
TinaS
  • Locked
  • Question Question
Quick one I think - question about Properties window in Form Design view
Replies
1
Views
497
dhookom
dhookom
applestoapples
  • Locked
  • Question Question
Create duplicate rows based on Qty field
Replies
7
Views
637
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top