Hi Kurt, > Now - within the Menu Designer you have the Options for each menu item - > and there is the "Skip For" option within the Prompt Options. As of > right now I am calling a procedure from the Skip For option to tell > FoxPro when to Skip (i.e. Not Allow access to a particular menu option). > Within this procedure that I create - I was attempting to call the BAR() > function - to tell me what Menu option was just selected. However, it > seems that it will NOT give the right value - due to a timing issue. > Since my procedure is being called from within the Skip For - the call > to my procedure actually occurs BEFORE the menu option is selected - and > as such - the BAR() function actually returns the Previously selected > menu option - NOT the menu option I am currently attempting to select. > I've never tried using the BAR() to determine what menu option was selected. How I have my security set up is (I've simplified this somewhat to make the explanation easier).:
User table with User Primary Key SecuredItems table with a Primary Key UserAccess table which has the User Primary Key and the SecuredItems Primary Key and a field specifying the type of access allowed (read only, none, full). I have a UDF which takes the current user Primary Key, a passed parameter of the Secured Items Primary Key and determines the access. So my Skip for in the menu might look like this: GetAccess(UserPK, SecuredItemspK) >= 8 It's a bit tedious to put all these calls in the menu initially, but it's a one off job. HTH -- Frank. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com/ Referrals are important to us. If you know of anyone who would benefit from our services, please contact me. We would appreciate the opportunity to work with them. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
