How to make a wildcard filter in Sharepoint?

Question

SharePoint

There are 4 lists: Plants, RTP, RTP_Plant, Works
Plants and RTP - directories
RTP can feed several plants and a plant can be powered by several RTP
RTP_Plant contains fields of the Substitution type from the above directories, i.e. when adding an element, we simply select RTP and Plant from drop-down lists
When adding an element to the Works list, we first select the Plant from the drop-down list, then after selecting the plant, we need to filter the RTP substitution according to the RTP_Plant table so that extra RTPs are not displayed.
The difficulty is that you have to filter the data source not just by another list, but also by the selected element on the form, i.e. The data source is RTP, you need to filter RTP_Plant by the selected plant, and then filter RTP by the filtered RTP_Plant
How to do? I tried everything through infopass forms

Answer 1

There are a lot of free ready-made solutions for using "dependent" lookups.
Here is one example:
sharepointlookup.codeplex.com
or
parentchildlookup.codeplex.com

Answer 2

If you have experience, then you can look towards JavaScript and CSR + SharePoint API, do your own rendering of Lookup fields and filter them by other values.