AnsweredAssumed Answered

Table relate only showing one-way results

Question asked by y536liu on Nov 13, 2017
Latest reply on Nov 15, 2017 by y536liu

Hi all,

I am trying to relate two tables in a one-to-many relationship.  Let's call the working table TableA (with the single entries of the match field) and the target table  (with the multiple entries for the match field) TableB. 


The relate process is successful, but when I choose a row in TableA to find the corresponding TableB entries, about half of them do not show up.  This leads me to think that the relate didn't work for half of them.  However, when I go to TableB to find the corresponding TableA entries for those same "missing relates", it works.  


I thought relate was supposed to be bi-directional?  Does anyone know what's going on and how to fix it so I can find my TableB entries through TableA?


Thank you,