Form Data Source Join Types
Views (3619)
Sheikh Sohail
6,125
Like
Share
ReportForm data source link type is a property of the form data source. We can add more than one tables as a data source to the form. Those data sources should has the table level relation, So, then the developer no need to work on the coding part to find the relation records. For example, if we create the order form, that order form has Student and student Attendance tables as form data sources. We can make part of both table of the form data source and can make link as per requirement.
For Instance, We Created Two Tables.
- Student
- Student Attendance
Then Create relation as per your requirement. I am using Normal relations.
Student
Student Attendance
Now create New Form and Add two Gird [StudentGrid] & [StudentAttendanceGird]
Lets begin
Passive Join Type
Passive form data source link type won't update the child data source automatically. For example if we select the parent table order then order details child data source won't update. If we need to update the child data source we need to call the child data source execute query method by program (code).
Active Join Type
Active link type update the child data sources without any delay when you select the parent table record. When you deal with more records it will be affect application performance.
Delay Join Type
Delay form data source link type is also same as active method the different is delay method won't update immediately when you select the parent record. It will update the child data source when you select the parent table, Ax use pause statement before update the child data source.
Inner join Type
Inner join form data source link type displays the rows that match with parent table and child table.
Outer join Type
Outer join form data source link type will return all parent records and matched child records. It will return all rows in the parent table.
Exists Join Type
Exist join form data source link type return matched rows of the parent table. It behaves like inner join but the different is once parent row matched with child records then stop the process and update in the grid, Ax won't consider how many records in child table for the parent row.
Not Exists Join Type
Not exist join form data source link type is totally opposite method to exist join. It will return the not matched parent records with child records.
This was originally posted here.
*This post is locked for comments