SharePoint 2007 and have site curate access only.
List-A has a column Name and that is a lookup to List-B, which only has names and no other information.
Now when looking at lookup columns in views the option displayed is a link to parent list. In my case List-B has not other info other then names but the names change frequently. And this lookup is used in many lists.
Is there any way to prevent a lookup column from being clickable so that the value looks like plain text in views?