Jun 7 2005, 01:43 PM
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.
Jun 7 2005, 08:25 PM
Create a multi-field unique index on EmployeeID and Month.
Jun 20 2005, 04:25 PM
Any chance of a bit more on this indexing. Can't seem to get it too worl re my issue.
Jun 20 2005, 04:49 PM
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.
Jun 20 2005, 06:53 PM
What John said
Jun 21 2005, 02:30 AM
Brilliant very simple solution to an issue i was trying to overcome.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here