View source for Basic – AJAX – Child Form Mgt


== Overview ==

Bxp allows for a user when creating or modifying a form to add a question type which allows for the Adding/Updating and Deletion of records in a child database. This Question type is called “Basic – AJAX – Child Form Mgt”.


== Question Settings ==

*	'''Child Form Id'''
**	This is simply the ID of the child form in bxp
*	'''Field that store parent link'''
**	This is the filed in the child form that contains the intCDA_X_Id of the parent from record i.e. the foreign key
**	''Example -'' strCDA_2_field_0_0
*	'''Custom Table CSS'''
**	This allows the user to apply their own custom CSS to the DIV that the rendered AJAX table is in. If no custom CSS is required simply add NULL to this option
*	'''Fields to render in Data Table'''
**	This should be the fields from the child form that you require to be included in the data table, each field should be separated by a | symbol
**	''Example -'' strCDA_2_field_0_1|strCDA_2_field_0_2|strCDA_2_field_0_3
*	'''Fields to Insert/Update'''
**	This should contain the fields in the child form that will be inserted to and updated, each field should be separated by a | symbol 
**	''Example  -'' strCDA_2_field_0_1|strCDA_2_field_0_2|strCDA_2_field_0_3|strCDA_2_field_0_4
*	'''Management Interface Question headings'''
**	This should be the headings that you want to assign to the questions when the Addition/Update interface is displayed on screen, each field should be separated by a | symbol
**	''Example –'' First Name|Surname|D.O.B|Phone Number
*	'''Data Table Column Headings'''
**	This should be the headings that you want to apply to each column in the data table, each field should be separated by a | symbol
**	''Example –'' First Name|Surname|D.O.B
*	'''Management Interface Question types'''
**	This should be the types of questions that you want to apply to the Addition/Update interface, each field should be separated by a | symbol
**	The following are the allowed question types
***	Text – will render a text box
***	Date – will render a date box
***	Datetime – will render a date time box
***	Yesno – will render a Yes/No drop down list
***	Truefalse – will render a True/False drop down list
***	Number[x] – will render a number list drop down list – replace X with the number to stop at i.e. x=50 will give you a number list of 1-50
***	Custom[x] – will render a custom drop down list of answer values in a child form question – replace x with the strCDA_X_field_X_X of the question you want to get the answer values for.