Making a unique field

[Hippo86]

Hi,
I have a database with an employee id field, date, start time and hours to be worked. I would like to add an unique field, maybe the employee id field and date field so the record has an unique entry. How can I have that field added to the database as they are entering the record? The data entry form uses the table direct, no query. I know I can concatenate using a query but I want to make sure 2 records for the same day is not added. Any suggestions would be welcome.

[TonyES]

Hi,
Open the table in design view and then select View | Indexes to activate the Indexes window and then enter a new index name then select the Employee ID field in the field name dropdown next to it now without entering a new index name, select the date field in the field name dropdown in the next row. This way, you create an index on two fields. Click in the index name again. Set the Unique property of the index to Yes in the lower half of the Indexes window. When finished click OK.
Cheers!

[Hippo86]

Thanks a look into it.