Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Location
    Ohio, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    making a unique field (access 2003)

    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. Thanks for any help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: making a unique field (access 2003)

    Open the table in design view.
    Select View | Indexes to activate the Indexes window.
    Enter a new index name.
    Select the Employee ID field in the field name dropdown next to it.
    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.
    Click OK.

  3. #3
    New Lounger
    Join Date
    Mar 2002
    Location
    Ohio, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: making a unique field (access 2003)

    Thanks, that worked great, didn't think it would be that easy.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •