8 Replies Latest reply on Sep 27, 2012 11:42 AM by liyangao

    how come the two records are not linked while they have the same linking ID

    liyangao

      I have two tables one is called participant table and the other is called survey table and they are linked by participantID. There is one participantID 49-01-016, which I can search and find in both tables. However, if these two records are not linked while other matching records are linked accordingly. In order to avoid any entry error, I re-entered the participantID in both tables. But still when I put the extra field of survey table::participantID on the participant layout, nothing shows up for this record while others are matched all right?

       

      What went wrong here? If the linking variables are the same, the two records should be linked? Why is this the only one messed up? Thank you very much for your response and help!!!