UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> avoid duplicates    
 
   
pompoon
post Jun 7 2005, 01:43 PM
Post #1

UtterAccess Member
Posts: 47
I have form that allows data entry of sales. I want to make it impossible to enter sales data for an employee and month twice. What is the proper way to do this?
the underlying table has sales, month, and an employee id that is keyed to a main table.
Go to the top of the page
 
+
ScottGem
post Jun 7 2005, 08:25 PM
Post #2

UtterAccess VIP / UA Clown
Posts: 25,199
From: LI, NY
Create a multi-field unique index on EmployeeID and Month.
Go to the top of the page
 
+
damonsha
post Jun 20 2005, 04:25 PM
Post #3

UtterAccess Enthusiast
Posts: 87
Scott

Any chance of a bit more on this indexing. Can't seem to get it too worl re my issue.

Cheers

Damon
Go to the top of the page
 
+
jmcwk
post Jun 20 2005, 04:49 PM
Post #4

UtterAccess VIP
Posts: 12,201
From: Tacoma, WA.
What Scott is saying is Open your table in design view and click the indexes icon in the menubar, place EmployeeID and Month in the Grid and change unique from No to yes this places a UNIQUE Index on those two fields.
Go to the top of the page
 
+
ScottGem
post Jun 20 2005, 06:53 PM
Post #5

UtterAccess VIP / UA Clown
Posts: 25,199
From: LI, NY
What John said (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif)
Go to the top of the page
 
+
damonsha
post Jun 21 2005, 02:30 AM
Post #6

UtterAccess Enthusiast
Posts: 87
Brilliant very simple solution to an issue i was trying to overcome.

Thanks

Damon
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 12:50 AM