Results 1 to 2 of 2
  1. #1
    Soutrik is offline Novice
    Windows 10 Access 2007
    Join Date
    Oct 2019
    Posts
    1

    How do i link a non PK column to another non PK column

    Link - ID , Copy ID , Topic ID , Topic
    Topic - Topic ID , Topic Name
    I want it so that if i write topic iD in link , i will get the corresponding name of topic
    So i tried this
    https://ibb.co/YyrhDYq
    And the error is No unique index , but hey I'm using the PK of Topic and FK of Link so why ?
    Thank you for any help and check the image out for my situation

  2. #2
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Hi the correct link is shown in the picture
    :
    Copy.copyID -> Link.CopyID and
    Topic.TopicID -> Link.TopicID

    When you want to write the topic in table link, use a combo box in a form that shows the name but writes the ID to the table

    kr

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 10
    Last Post: 03-16-2018, 08:26 AM
  2. Replies: 4
    Last Post: 11-29-2017, 10:01 AM
  3. Replies: 1
    Last Post: 02-19-2016, 08:16 AM
  4. Replies: 14
    Last Post: 07-13-2015, 12:47 PM
  5. Replies: 2
    Last Post: 09-09-2012, 07:45 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums