In the Database Script in the PostOpen event, I have the following command:
@If(@IsMember(“[Approvers]”;@UserRoles);“”;@Command([OpenNavigator];“ApprvNav”;“1”))
I want the Approvers to see a different Navigator than the rest of the people see. What am I missing?
Subject: RE: How to display specified navigator?
I’m sorry, you’re using a navigator design element? Why?
It seems you might better use an outline with hide formulas on certain entries.
Alternatively, you could have a separate page (or navigator, if you insist) for the two groups, and use a frameset with computed frame contents to decide which to display.
Postopen event is really the wrong place for this.
Subject: How to display specified navigator?
@If(@Name([CN];@UserName) = “Person Name”;@Command([OpenNavigator];“nav1”);
@Command([OpenNavigator];“nav2”))
This works for me.
You don’t say what happens when you open the db.
I suspect it’s because of the “” in your if statement. You may need to either specify a view or possibly @Return(“”) to handle the ‘no’ case.
I’d also concur with Andre - check out outlines and/or framesets. You can get so very tricky with these things that it’s amazing. It took me a while to warm up to them but now that I’ve used them for a while, I rarely touch navigators any more.
HTH
Doug