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.

Create a multi-field unique index on EmployeeID and Month.

Scott

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

Cheers

Damon

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.

What John said

Brilliant very simple solution to an issue i was trying to overcome.

Thanks

Damon