Self Relating table -lookup and report
So I have tried to create a table related to itself. I am maintaining a staff table which join itselfs to maintain its manager hierarchy information. Now I want to create a report based on the current...
Forum Discussion
easy, just filter the report where the manager userid "is the current user". That should be offered as a choice in the report filter.
If it's is not offered up as choice you can use the somewhat obscure legacy notation of _curuser_ to compare the userid field to (yes, with those leading and trailing underscores). Or if necessary create a field called Current User of type formula user with a formula of
User()
If it's is not offered up as choice you can use the somewhat obscure legacy notation of _curuser_ to compare the userid field to (yes, with those leading and trailing underscores). Or if necessary create a field called Current User of type formula user with a formula of
User()
Let me try this approach and get back. Thank you for your response. appreciate the help