I am facing strange problem. We have lookup on Product object which refers to product group. When we query or view product we can see the ID of product group but not name as it happens in case of normal lookup field.
When we access this field in code we get "Insufficient access error"
My question is why its behaving like this? Ideally it should delete the reference of id in lookup when the parent record is deleted?