basenine 5/28/2018 1:27:22 AM
I've read and re-read your post here a few times and can only gather that when you say
"....is in the child record as a lookup and so CAN be used in table access rights."
You meant "....CAN'T be used in table access rights."
However, I've successfully been able to achieve what your requiring using this formula:
Obviously replace the [ActivityType] (which is a lookup from the parent record in my application), with your correct field.
Be careful using In() or Contains()...this may be where the problem is occurring...
In() needs to be exact wording and you can string a few together: In([YOUR_CRITERIA],"Locked","Not Open","Closed")
Contains() is broader in a sense, but comes with it's own set of issues
Best of luck,