private void initDropDowns()
{
// ID is table id, look it up from the database
var defaultFromFieldText = "(None)";
var defaultRelationshipType = "PARENT";
var defaultToTableText = "(None)";
var defaultToFieldText = "(None)";
if (ID > -1)
{
var ds = AdminProxy.ListTableRelationships(FromTableID, ID);
var dt = ds.Tables["list_table_relationships"];
if (dt.Rows.Count > 0)
{
var dr = dt.Rows[0];
defaultFromFieldText = dr["field_name"].ToString();
defaultRelationshipType = dr["relationship_type_tag"].ToString();
defaultToTableText = dr["table_name2"].ToString();
defaultToFieldText = dr["field_name2"].ToString();
}
}
// init From
txtChildTableName.Text = FromTableName;
initTableFieldDropDown(ddlChildField, FromTableID, true, "(None)", false, chkChildOnlyForeignKeys.Checked);
ddlChildField.SelectedIndex = ddlChildField.FindString(defaultFromFieldText);
// init Relationship
if (defaultRelationshipType.ToUpper().Contains("OWNER"))
{
chkOwner.Checked = true;
}
// init To
initTableDropDown(ddlParentTable, true, "(None)", -1);
ddlParentTable.SelectedIndex = ddlParentTable.FindString(defaultToTableText);
initTableFieldDropDown(ddlParentField, Toolkit.ToInt32(ddlParentTable.SelectedValue, -1), true, "(None)", chkParentOnlyPrimaryKeys.Checked, false);
ddlParentField.SelectedIndex = ddlParentField.FindString(defaultToFieldText);
syncGui();
}
