Best way to create Master-Detail Forms / Sub-Forms
What is the best way to create a master - detail form when a master has multiple sub-forms where each sub-form needs to be entered and maintained by a different role
1. Create a master form and then in the master form add sub-forms. Assign access rights for each sub-form based on roles. I guess in the form entry and the form report view this will show only those sub-forms assigned to a particular role when they are viewing it. Also in the Record View it lets you select the sub-forms to be added to the view.
2. Create a master form. Create individual sub-forms as forms with the master key as a field to link to the master. In this the master form report can have a custom action button which when clicked can call the sub-form based on the permissions for the user and pass the master key to the sub-form and disable the master key field. In this setup If I want to create a Record Summary view then how can the individual sub-forms be linked to the master form as they will not show up in the record viiew.
Eg master form
Supplier ID : Supplier Name : Supplier City : Supplier Reg No
Sub-Form 1: Product ID, Product Descrip, Product qty, Product Price (Multiple products managed by INVENTORY ROLE)
Sub-Form 2: Agreement No : Agreement Date : Agreement Upload (Multiple agreements managed by LEGAL ROLE )
Sub-Form 3: Address : City : Pincode : State (multiple supplier locations MANAGED by LOGISTICS ROLE)
The reporting would be such that the MIS Role can see a report with The Master for details and all the three Sub-Forms whereas the other roles only get to see reports with their own sub-forms.
What would be the best way to create these forms and link them to the master such that the Logistics role gets to see only the Sub-Form 2, Legal Role gets to see only Sub-Form 1 etc
Thanks