AnsweredAssumed Answered

Not able to see related data unless the join table has been opened

Question asked by user19174 on May 5, 2015
Latest reply on May 6, 2015 by user19174

I have a weird thing happening, and am hoping someone can shed some light on where I have gone wrong, as I am pretty sure this is not expected behavior.

 

I have 3 tables, A, B C.  Table A and Table C are connected through B.  All key fields are stored as text and indexed.

 

I have a layout based on table A where I want to show some related data from table C.  The data is only visible if I first open a table B layout which appears to refresh the join and then the related records in C are visible from Table A.

 

Am I missing something here?

 

JJ

Outcomes