SharePoint Cascaded Lookup

SharePoint cascaded lookup; cross-site lookup data in SharePoint list; filter SharePoint columns, filter by building parent-child relationship; convert between SharePoint lookup/cross-site lookup/cascaded lookup