Condition from other table in relationship

Idea created by tomasd on Jun 14, 2016
    Active
    Score-2

    I have 3 tables. Main table is Instrument and can be connected to other X instruments via Connection table. I need to filter InstrumentConnected with condition from table Instrument (e.g. ID_company). It should be possible, because all tables are related.

     

    Here is example: