This is a bug. Similar missed relationships have been noted here in this board and in my own file.
Please click on the "Board Information" at the top right of this screen. Click on FTM Feedback. Select the correpsondence to be Bug Report. Copy and paste your query into the message space.