Form ID |
Table Name |
|---|---|
leaveApplication |
leave_application |
leaveDetails |
leave_details |
Relationship: One leave application has one leave details.
Parent Form: leaveApplication
Child form: leaveDetails
Linking the child form to the parent form
One to One relationship
One will only need to select on which form to be used in the subform's properties if it is a 1-1 relationship. The child record will use the same ID as the parent form as the primary key.
"Parent Field to keep Subform ID" can be set in this case so that the parent form has a reference to the child record.
Sample data
Table: leave_application
id |
leave_details_id |
.... |
|---|---|---|
1550 |
1550 |
.... |
Table: leave_details
id |
leave_application_id |
|
|---|---|---|
1550 |
1550 |
.... |