Results 1 to 3 of 3

Thread: unique name

  1. #1
    Join Date
    Jul 2003
    Posts
    421

    unique name

    Hi

    I don't have much experience in access, I created a department table and I want to make some validation to stop same department be input twice, I have department id as prime key

    thank you
    ________
    ANGELINA JOLIE PICTURES
    Last edited by sql; 03-06-2011 at 01:24 AM.

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    1. Make department name as primary key
    or
    2. Create index with (no duplicates) on the department name

    -Rightclick on the table - Design table - click on 'department name' - click in 'index' in the property window

  3. #3
    Join Date
    Jul 2003
    Posts
    421
    Mak:
    thank you!
    ________
    Honda rc160
    Last edited by sql; 03-06-2011 at 01:24 AM.

Posting Permissions

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