== Overview ==
== Overview ==bxp has the ability to link any two forms together, in a parent child form structure. Any two forms can be linked if the following two conditions are met:
1) A field in the parent form contains a value that is also present in all of the records in a child form.
2) There is a field in the child database specifically used to store the link between a parent and child form.
== Linking records in a child form to a parent form ==
To perform record linking in bxp, navigate the following system path: Main Menu > Form Management > Form - Data Cleaning - Mass Update - Parent-Child From Record Linking. After clicking on this link you will be redirected to the first page of this process, . From here you will need to select the parent form that will act as the parent and the child form that will act as the child. These forms cannot be the same, as one form cannot be the patent parent and the child at the same time. There is no limit to the amount of child forms a parent form can have. A parent form can also be a child form for another. [[File:RecordLinking_Page1.png|800px]]
There is no limit to After selecting the amount of child two forms a parent form can have, A parent form can also the following settings will need to be a child form to another.set:
[[File:RecordLinking_Page1'''1) Update all records or only the non-linked records -''' This setting allows the user to perform the record linking process on the entire child database, or just the records in the child database that are not linked to a parent record.png]]
'''2) Matching field in the Parent form -''' This should contain the field in the parent form that contains a search value that matches a record in the child form
After selecting '''3) Matching field in the two forms that will act as Child form -''' This should contain the field in the parent and child, form that contains a search value that matches a bxp user will be redirect to record in the second page of this process. On this page the following settings will have to be set:parent form
'''4) Field to store the link -''' This should contain the field in the child form that will store the link between the child and parent form, it is recommended that this field is a ''campaign search question type''
1) Update all records or only the non-linked records - This setting allows the user to select if they wish to perform the record linking process on the entire child database or just the records in the child database that are not linked to a parent record.
2When bxp is performing the record linking function it will group all of the records, or just the non-linked records (depending on the users choice of function) Matching . Using the matching field in of the Parent child form - This should contain search for a match in the filed in matching field of the parent form that contains a search value matches . If there is a match, bxp will insert the bxp record in id of the parent form into the selected linking field of the child form. If no match is found the linking field of the child formwill contain 0.
3) Matching field in Once the user has selected the desired fields they simply need to click the ''Perform Record Linking'' button at the bottom of the Child form - This should contain page. Once this button is clicked the filed record linking process will commence. Depending on the amount of records in the child form that contains database this process can take up a search value that matches a record in the parent formminute to complete.
4) Field to store the link - This should contain the filed in the child form that will store the link between the child and parent form, it is recommended that this field is a ''campaign search question type''
[[File:RecordLinking_Page2.png|800px]]
When bxp is performing the record linking function it will group all of the records or just the no-linked records (depending on the users choice of function), and using the matching field of the child form search for a match in the matching field of the parent form. If there is a match bxp will insert the bxp record id of the parent form into the selected linking filed of the child form. If no match is found the linking filed of the child form will contain 0.
Once When the user record linking process has selected completed, the desired fields they simply need user will be redirected to click the ''Perform Record Linking'' button at the bottom final page of the page, once this button process. The purpose of these pages is clicked to convey to the user the successful completion of the record linking process will commence. Depending on This page generates a count of the amount number of records in the child database this process can take up that did not have a valid parent record. If there are orphan records found, bxp will generate a complete list of these records on screen and provide a user with a minute button to click through to completean orpahn record and link it manually.
[[File:RecordLinking_Page2RecordLinking_Page3.png|800px]]
Once the record linking process has completed, the user will be redirected to the final page of this process. This pages purpose is to convey to the user the successful completion of the record linking process, this page renders a count of how many records in the child database that did not have a valid parent record found. If there are orphan records found, bxp will render a complete list of these records on screen and provide a user with a button to click through to an orpahn record and link it manually.[[Category:Module Specific:Form Management]]