This video shows how you can implement a SharePoint lookup field that is filtered by a remote list's view.
This video shows how to create cascaded lookup fields, such as Region->Country->City, by using the KWizCom's Cascading Lookup Plus field type.
When creating a lookup field in a source list to a remote list you can configure the Cascading Lookup Plus field to automatically create a reverse lookup from the remote list back to source list. This way you provide end-users with a 2-way connection between entities, enabling them to navigate from any side of the connection and see the connected items. Example: When connecting between Products and Orders lists, when viewing an Order you'll be able to see which products are included in that order, and when viewing a product you'll be able to see in which orders this product is included.
This video shows you how to configure the Cascading Lookup column to connect a Project to its Tasks. This way users can easily create/edit tasks connected to a project, from within the project item without having to go to the Tasks list - results in a much quicker and smoother work flow.