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!!!