Filtered Lookup is an advanced field type for SharePoint (WSS and MOSS) that can be replacement for standard out-of-the-box Lookup column. It can be added to a list or a document library from SharePoint user interface or using a feature.

Related Items field type allows to link selected search results to a document or list item as a collection of permalinks or normal URLs.