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?