Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2013
    Posts
    82

    Unanswered: Change Property of Field in Linked Table

    I have a Part Number table with a drop down field on a form for these part numbers. Is there a way to change the property of the field in the table to not allow duplicates?

    When I try to change the indexed property to not allow duplicates Access pops up with it can't save changes to linked tables.

    Thanks for the help.

  2. #2
    Join Date
    Aug 2013
    Posts
    82

    Change Property of Field in Linked Table

    I attached a screen shot of the relationships.

    Would I have to remove the links to the tables and then put them back in order to not allow duplicates of part numbers in the Part Number table?
    Attached Thumbnails Attached Thumbnails Relationships.png  

Posting Permissions

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