5 related tables (one-to-many relationship) design in forms

 
1
0
-1

Good day to all.

I have 5 entities which i need to reflect it on the forms.
They are inter-related and with dependencies (see attached image)


*  Modules can have the ff. data (user mngt., auditing, data recording)

*  Roles can have selected modules only (selection of modules should be a checkbox list)

*  User can have limited grants based on Role (i think this is the hard part but same using checkbox list)

Is this possible to implement in the forms builder?

(There is also a similar scenario but in a different process that's why i used this drawing for clearer view)

Your help is highly appreciated.

Thank you.

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      You can start with designing 5 such forms with the table named as per your ERD.

      Then, use grid or selectbox to maintain the relationship. You may need to use multirow binder inside your grid. You can check out the sample expenses claim app where relationship such as:-

      1. claim has many item
      2. each item has one category

      are maintained.

      cheers

        CommentAdd your comment...
      1.  
        1
        0
        -1

        Hi Christine

        Joget already has an internal Setup Users, User Role and User Groups screens, as follows:

        You can also connect to a Directory Manager such as LDAP or Active Directory.

          CommentAdd your comment...