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?