Master Detail form

[nnarayanan]

Hi

Can some one describe me how to develop a master detail form using the Module Builder?

Regards
Narayanan

[andopes]

Hi Narayanan

Can you explain what is a Master Detail Form?

[nnarayanan]

Hi,

Sorry for not providing the details in my earlier question. Basically consider the following Employee Attendance.

Assuming that we have two tables Employee Master and Attendance Details. The structure is as follows

Employee Master
===============
Employee ID --> Primary Key
Employee Name
Department Name
Date of Join

Attendance Details
================
Employee id --> Foreign Key to Employee Master
Date
IsPresent --> Boolean if True then employee is present for that day or absent for that day.

Now coming back to my layout of the form (Attendance Details Form)

---------------------------------------------------------------------------------------------------------------------------------------------------------
MASTER

Employee : <Combo Box to select the Employee> (On selecting the employee the below are displayed

Department Name: <display> Date of Join <Display>

---------------------------------------------------------------------------------------------------------------------------------------------------------
DETAILS

Employee Attendance Details

Date Present / Absent
=========== ===============
01-Nov-08 True <edit button> <delete button>
02-Nov-08 True <edit button> <delete button>
.......


<add new Attendance button>
================================================== ===========================================
if you look at the above layout basically I am trying to enter the Attendance details for an employee. Now when a employee is selected, the details like Department, Date of Join are displayed in the master layout and in the detail layout if the attendance table has any records for this employee then they will be listed out and each row will have a edit and delete button. Finally we will have add button to add new attendance for this employee. (The detail can be a editable grid)

Is there any way I can achieve this in SugarCRM using Module Builder?

Thanks for your help

Regards
Narayanan

[andopes]

So you want to create a "Attendance Details" dynamic table into "Employee Master" EditView, right?
It is possible but it take so much time.

Regards