private void RefreshCooperatorList()
        {
            DataSet ds          = new DataSet();
            string  findText    = "";
            string  searchPKeys = "";

            // First get the cooperator_ids for the orginal search criteria (_originalPKeys)...
            ds          = _sharedUtils.GetWebServiceData("get_cooperator", _originalPKeys, 0, 0);
            searchPKeys = ":cooperatorid=";
            if (ds.Tables.Contains("get_cooperator"))
            {
                foreach (DataRow dr in ds.Tables["get_cooperator"].Rows)
                {
                    searchPKeys += dr["cooperator_id"].ToString() + ",";
                }
            }

            // Now get the cooperator_ids from the local LU table that match the lastname and first name...
            if (!string.IsNullOrEmpty(ux_textboxLastName.Text))
            {
                findText += ux_textboxLastName.Text + "%";
            }
            if (!string.IsNullOrEmpty(ux_textboxFirstName.Text))
            {
                findText += ux_textboxFirstName.Text + "%";
            }
            if (!string.IsNullOrEmpty(findText))
            {
                DataTable dt = new DataTable();

                dt = _sharedUtils.LookupTablesGetMatchingRows("cooperator_lookup", findText, 1000);
                foreach (DataRow dr in dt.Rows)
                {
                    searchPKeys += dr["value_member"].ToString() + ",";
                }
            }

            // Remove the last trailing comma...
            searchPKeys = searchPKeys.TrimEnd(',');

            // Finally go get the full collection of cooperator_ids...
            ds = _sharedUtils.GetWebServiceData("get_cooperator", searchPKeys, 0, 0);
            if (ds.Tables.Contains("get_cooperator"))
            {
                _cooperator = ds.Tables["get_cooperator"].Copy();
            }
            else if (_cooperator == null)
            {
                _cooperator = new DataTable();
            }
            // And then update the binding source's data...
            _cooperatorBindingSource.DataSource = _cooperator;
        }