Drupal 7 Link CCK text field to Node ID
Include cck text field and node id in your view's field list and then you can make your text field as link to node id.

Also for the filtration you can use contextual filters if required one is not available you can use relations.