Home » Developer & Programmer » Forms » Tree for the forms (Forms 10g)
Tree for the forms [message #409830] Wed, 24 June 2009 03:46 Go to next message
samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong
Senior Member

Hi,

I have around 30 forms and reports in my application and i have assigned the rights for the different user. Now i want to create the tree for this as per the rights given to the particular user tree has to be created.

How to do this please help me

Samit Gandhi
Re: Tree for the forms [message #409942 is a reply to message #409830] Wed, 24 June 2009 09:33 Go to previous messageGo to next message
djbabu
Messages: 14
Registered: May 2009
Junior Member
Can I suggest you a different solution for this :


USER_Master --- List all your users here
~~~~~~~~~~~~

User_id
Role_id
User_name
password_name
First_name
Last_name


Role_Master --- Create Roles List Manager, Finance, Accounts, End user..
~~~~~~~~~~~

Role_ID
Role_name


Form_Master --- List all your 20 forms here..
~~~~~~~~~~~

Form_ID
Form_Name


Role_Form --- Specify the Role Form Mapping...
~~~~~~~~~~~

Role_ID
Form_ID


Steps :
(0) Create & Populate the above 4 tables appropriately.
(1) Create a form to authenticate the user by {User_name/password_name}..
(2) Display the available forms for the user and to access it.


Re: Tree for the forms [message #409946 is a reply to message #409830] Wed, 24 June 2009 09:37 Go to previous message
djbabu
Messages: 14
Registered: May 2009
Junior Member

Please update the following, I thought its just 20 forms..

Instead of this :

Form_Master --- List all your 20 forms here..
~~~~~~~~~~~
Form_ID
Form_Name




Module_Master --- List all your 30 Forms/Reports here..
~~~~~~~~~~~
Module_ID
Module_Name

Role_Module --- Specify the Role Module Mapping ...
~~~~~~~~~~~
Role_ID
Module_ID

Previous Topic: Migration from Forms 6i to Forms 10g - Data update problem
Next Topic: Button trigger filling multiple fields in detail-form ?
Goto Forum:
  


Current Time: Fri Dec 09 13:30:04 CST 2016

Total time taken to generate the page: 0.16584 seconds