Hi Rafael My Accounts system works on this principle. I Have a Separate Employee table which holds data relative to the Employee i.e. Name Address Birth date Start Date Current How many days holiday they are allowed and how many they have taken etc but also there login name (What they log into the Computer as, the password and a privilege level field (PrivLevel) which is numeric from 1 to 9 I have set up a Matrix of Privilege level against form which decides what menu tabs the employee can see enabled then use s skip for in the Menu. I.e. Skip for (Application object).PrivLevel < 5
Is this the sort of thing you are looking for? I have been looking at hacking the Menu table as the application starts then recompiling the .mpr before doing the menu.mpr but haven't had the time to persevere on that line of thought. I did get it working but it caused too much delay opening the application. Cheers Peter -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rafael Copquin Sent: 14 June 2006 18:46 To: [email protected] Subject: custom menus I am trying to develop a menu system geared to the user. IOW, user A logs in and his/her particular menu appears, which is different from user B's menu. This is related to permissions in the menu items. That is, for instance, if I have a payroll function in the menu and want one user to have full access to all items in the menu, while other users have limited access, I just want to develop special menus for each. My idea is to put all pads, popups and menu bars in a table and have another one with users like this: Menu prompt supervisor clerk A clerk B Payroll x x Employees x x Employee personal data x x Employee salaries data x etc In the above example, the supervisor has full access while clerk A can only see all data except salaries and clerk B has no access to the payroll function at all. Is there anything done along these lines, so I won't have to spend time "re-inventing the wheel" ? Can you share ideas, or code or classes or whatever? TIA Rafael Copquin www.copquin.com.ar Universal Thread Magazine - Translation Coordinator Treasurer - Microsoft Users Group of Argentina (MUG) www.mug.org.ar [excessive quoting removed by server] _______________________________________________ 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 ** 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.

