EpiDashboard.RelatedConnection dashboard_RelatedDataRequested()
        {
            if (this.dashboard.DashboardHelper == null)
            {
                Epi.Windows.MsgBox.ShowInformation(SharedStrings.DASHBOARD_CANNOT_RELATE_NO_DATA_SOURCE);
                return(null);
            }

            // May arrive here by opening a canvas file without going through normal request routine.
            this.dashboardHelper = this.dashboard.DashboardHelper;

            Epi.Windows.Dialogs.ReadRelatedDialog dlg = new Dialogs.ReadRelatedDialog(this.dashboard.DashboardHelper.TableColumnNames);

            if (dashboard.DashboardHelper.IsUsingEpiProject)
            {
                Dictionary <string, string> tableColumnNamesFiltered = new Dictionary <string, string>();

                foreach (KeyValuePair <string, string> kvp in this.dashboardHelper.TableColumnNames)
                {
                    if (kvp.Value.ToLowerInvariant() != "epi.fields.groupfield")
                    {
                        tableColumnNamesFiltered.Add(kvp.Key, kvp.Value);
                    }
                }

                dlg = new Dialogs.ReadRelatedDialog(this.dashboard.DashboardHelper.View.Project, tableColumnNamesFiltered);
            }
            EpiDashboard.RelatedConnection relatedConnection = null;

            if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                if (dlg.SelectedDataSource is Project && dlg.SelectedItemType == Dialogs.SelectedItemType.Form)
                {
                    Project   project  = (Project)dlg.SelectedDataSource;
                    View      view     = project.GetViewByName(dlg.SelectedDataMember);
                    IDbDriver dbDriver = DBReadExecute.GetDataDriver(project.FilePath);
                    relatedConnection = new EpiDashboard.RelatedConnection(view, dbDriver, dlg.ParentKeyField, dlg.ChildKeyField, dlg.UseUnmatched, false);

                    if (dashboardHelper.IsUsingEpiProject && dashboardHelper.View.Project.FilePath == project.FilePath)
                    {
                        relatedConnection.SameDataSource = true;
                    }
                }
                else if (dlg.SelectedDataSource is Project && dlg.SelectedItemType == Dialogs.SelectedItemType.Table)
                {
                    Project   project  = (Project)dlg.SelectedDataSource;
                    IDbDriver dbDriver = project.CollectedData.GetDbDriver();
                    relatedConnection = new EpiDashboard.RelatedConnection(dlg.SelectedDataMember, dbDriver, dlg.ParentKeyField, dlg.ChildKeyField, dlg.UseUnmatched, false);

                    if (dashboardHelper.IsUsingEpiProject && dashboardHelper.View.Project.FilePath == project.FilePath)
                    {
                        relatedConnection.SameDataSource = true;
                    }
                }
                else
                {
                    IDbDriver dbDriver = (IDbDriver)dlg.SelectedDataSource;
                    relatedConnection = new EpiDashboard.RelatedConnection(dlg.SelectedDataMember, dbDriver, dlg.ParentKeyField, dlg.ChildKeyField, dlg.UseUnmatched, false);
                }

                dashboard.ReCacheDataSource(false);

                return(relatedConnection);
            }
            return(null);
        }
        EpiDashboard.RelatedConnection dashboard_RelatedDataRequested()
        {
            if (this.dashboard.DashboardHelper == null)
            {
                Epi.Windows.MsgBox.ShowInformation(SharedStrings.DASHBOARD_CANNOT_RELATE_NO_DATA_SOURCE);
                return null;
            }

            // May arrive here by opening a canvas file without going through normal request routine.
            this.dashboardHelper = this.dashboard.DashboardHelper;

            Epi.Windows.Dialogs.ReadRelatedDialog dlg = new Dialogs.ReadRelatedDialog(this.dashboard.DashboardHelper.TableColumnNames);

            if (dashboard.DashboardHelper.IsUsingEpiProject)
            {
                Dictionary<string, string> tableColumnNamesFiltered = new Dictionary<string, string>();

                foreach (KeyValuePair<string, string> kvp in this.dashboardHelper.TableColumnNames)
                {
                    if (kvp.Value.ToLower() != "epi.fields.groupfield")
                    {
                        tableColumnNamesFiltered.Add(kvp.Key, kvp.Value);
                    }
                }

                dlg = new Dialogs.ReadRelatedDialog(this.dashboard.DashboardHelper.View.Project, tableColumnNamesFiltered);
            }
            EpiDashboard.RelatedConnection relatedConnection = null;

            if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                if (dlg.SelectedDataSource is Project && dlg.SelectedItemType == Dialogs.SelectedItemType.Form)
                {
                    Project project = (Project)dlg.SelectedDataSource;
                    View view = project.GetViewByName(dlg.SelectedDataMember);
                    IDbDriver dbDriver = DBReadExecute.GetDataDriver(project.FilePath);
                    relatedConnection = new EpiDashboard.RelatedConnection(view, dbDriver, dlg.ParentKeyField, dlg.ChildKeyField, dlg.UseUnmatched, false);

                    if (dashboardHelper.IsUsingEpiProject && dashboardHelper.View.Project.FilePath == project.FilePath)
                    {
                        relatedConnection.SameDataSource = true;
                    }
                }
                else if (dlg.SelectedDataSource is Project && dlg.SelectedItemType == Dialogs.SelectedItemType.Table)
                {
                    Project project = (Project)dlg.SelectedDataSource;
                    IDbDriver dbDriver = project.CollectedData.GetDbDriver();
                    relatedConnection = new EpiDashboard.RelatedConnection(dlg.SelectedDataMember, dbDriver, dlg.ParentKeyField, dlg.ChildKeyField, dlg.UseUnmatched, false);

                    if (dashboardHelper.IsUsingEpiProject && dashboardHelper.View.Project.FilePath == project.FilePath)
                    {
                        relatedConnection.SameDataSource = true;
                    }
                }
                else
                {
                    IDbDriver dbDriver = (IDbDriver)dlg.SelectedDataSource;
                    relatedConnection = new EpiDashboard.RelatedConnection(dlg.SelectedDataMember, dbDriver, dlg.ParentKeyField, dlg.ChildKeyField, dlg.UseUnmatched, false);
                }

                dashboard.ReCacheDataSource(false);

                return relatedConnection;
            }
            return null;
        }