md dynamic form child

Database Table

Name	md_dynamic_form_child
Prefix	dyc
Group Item	Child Form
Initial Build	2006.02

Overview

Child Forms that link to the parent form.

Columns

Name	Description	Datatype	Notes
dyc_key	Unique Key	av_key
dyc_description	Child Form Description	nvarchar(100)
dyc_grid_title	Title for Grid	nvarchar(100)
dyc_grid_comments	Comments for Grid	nvarchar(250)
dyc_title_icon	Title Icon	nvarchar(50)
dyc_dyn_key	Parent Form	av_key
dyc_dyn_key_child	Destination Form	av_key
dyc_order	Order	av_integer
dyc_below_control	Place Below Control	nvarchar(50)
dyc_child_key_column	Child Key Column	nvarchar(50)
dyc_sql	Select SQL	av_text
dyc_allow_add	Allow Add?	av_flag
dyc_allow_edit	Allow Edit?	av_flag
dyc_allow_delete	Allow Delete?	av_flag
dyc_allow_goto	Allow Go To?	av_flag
dyc_allow_menu	Allow Menu?	av_flag
dyc_wiz_key	Wizard Form	av_key
dyc_dyc_key	Parent Child Form	av_key
dyc_is_recursive	Is Recursive?	av_flag
dyc_dyn_key_goto	Goto Form	av_key
dyc_goto_key_column	Goto Key Column	nvarchar(50)
dyc_dyn_key_menu	Menu Form	av_key
dyc_menu_key_column	Menu Key Column	nvarchar(50)
dyc_static_edit_form	Static Edit Form	nvarchar(50)
dyc_same_window_add	Same Window for Add?	av_flag
dyc_same_window_edit	Same Window for Edit?	av_flag
dyc_width	Width	av_integer
dyc_height	Height	av_integer
dyc_cssclass	Stylesheet Class	nvarchar(50)
dyc_has_override_links	Has Override Links?	av_flag
dyc_sql_visible	Visible SQL	av_text
dyc_sql_readonly	Read Only SQL	av_text
dyc_sql_row_visible	Row Visible SQL	av_text
dyc_sql_row_readonly	Row Read Only SQL	av_text
dyc_allow_export	Allow Export?	av_flag
dyc_sql_add_visible	Allow Add visible SQL	av_text
dyc_add_user	Add User	av_user
dyc_add_date	Add Date	av_date
dyc_change_user	Change User	av_user
dyc_change_date	Change Date	av_date
dyc_delete_flag	Delete Flag	av_delete_flag
dyc_entity_key	Entity Key	av_key

Parent Tables

Parent Table	Parent Key	Child Key	Join
md_dynamic_form	dyn_key	dyc_dyn_key	dyc_dyn_key = dyn_key
md_dynamic_form	dyn_key	dyc_dyn_key_child	dyc_dyn_key_child = dyn_key

Child Tables

Child Table	Parent Key	Child Key	Join
md_dynamic_form_child_link	dyc_key	dyl_dyc_key	dyl_dyc_key = dyc_key
md_dynamic_form_child_x_group	dyc_key	cgx_dyc_key	cgx_dyc_key = dyc_key
md_dynamic_profile_detail	dyc_key	dpd_dyc_key	dpd_dyc_key = dyc_key