Index: Scheduling/trunk/cs/bsdx0200GUISourceCode/dsRebookAppts.Designer.cs
===================================================================
--- Scheduling/trunk/cs/bsdx0200GUISourceCode/dsRebookAppts.Designer.cs	(revision 614)
+++ Scheduling/trunk/cs/bsdx0200GUISourceCode/dsRebookAppts.Designer.cs	(revision 772)
@@ -2,5 +2,5 @@
 // <auto-generated>
 //     This code was generated by a tool.
-//     Runtime Version:2.0.50727.3053
+//     Runtime Version:2.0.50727.3603
 //
 //     Changes to this file may cause incorrect behavior and will be lost if
@@ -30,5 +30,5 @@
         private BSDXResourceDataTable tableBSDXResource;
         
-        private global::System.Data.DataRelation relationBSDXResourcePatientAppts;
+        private global::System.Data.DataRelation relationFK_BSDXResource_PatientAppts;
         
         private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
@@ -207,5 +207,5 @@
                 }
             }
-            this.relationBSDXResourcePatientAppts = this.Relations["BSDXResourcePatientAppts"];
+            this.relationFK_BSDXResource_PatientAppts = this.Relations["FK_BSDXResource_PatientAppts"];
         }
         
@@ -222,5 +222,5 @@
             base.Tables.Add(this.tableBSDXResource);
             global::System.Data.ForeignKeyConstraint fkc;
-            fkc = new global::System.Data.ForeignKeyConstraint("BSDXResourcePatientAppts", new global::System.Data.DataColumn[] {
+            fkc = new global::System.Data.ForeignKeyConstraint("FK_BSDXResource_PatientAppts", new global::System.Data.DataColumn[] {
                         this.tableBSDXResource.RESOURCEIDColumn}, new global::System.Data.DataColumn[] {
                         this.tablePatientAppts.RESOURCEIDColumn});
@@ -229,8 +229,8 @@
             fkc.DeleteRule = global::System.Data.Rule.Cascade;
             fkc.UpdateRule = global::System.Data.Rule.Cascade;
-            this.relationBSDXResourcePatientAppts = new global::System.Data.DataRelation("BSDXResourcePatientAppts", new global::System.Data.DataColumn[] {
+            this.relationFK_BSDXResource_PatientAppts = new global::System.Data.DataRelation("FK_BSDXResource_PatientAppts", new global::System.Data.DataColumn[] {
                         this.tableBSDXResource.RESOURCEIDColumn}, new global::System.Data.DataColumn[] {
                         this.tablePatientAppts.RESOURCEIDColumn}, false);
-            this.Relations.Add(this.relationBSDXResourcePatientAppts);
+            this.Relations.Add(this.relationFK_BSDXResource_PatientAppts);
         }
         
@@ -530,5 +530,5 @@
                         string Clinic, 
                         string TypeStatus, 
-                        BSDXResourceRow parentBSDXResourceRowByBSDXResourcePatientAppts, 
+                        BSDXResourceRow parentBSDXResourceRowByFK_BSDXResource_PatientAppts, 
                         string APPT_MADE_BY, 
                         System.DateTime DATE_APPT_MADE, 
@@ -559,6 +559,6 @@
                         HOMEPHONE,
                         OldApptDate};
-                if ((parentBSDXResourceRowByBSDXResourcePatientAppts != null)) {
-                    columnValuesArray[7] = parentBSDXResourceRowByBSDXResourcePatientAppts[0];
+                if ((parentBSDXResourceRowByFK_BSDXResource_PatientAppts != null)) {
+                    columnValuesArray[7] = parentBSDXResourceRowByFK_BSDXResource_PatientAppts[0];
                 }
                 rowPatientApptsRow.ItemArray = columnValuesArray;
@@ -616,5 +616,5 @@
                 this.columnTypeStatus = new global::System.Data.DataColumn("TypeStatus", typeof(string), null, global::System.Data.MappingType.Element);
                 base.Columns.Add(this.columnTypeStatus);
-                this.columnRESOURCEID = new global::System.Data.DataColumn("RESOURCEID", typeof(uint), null, global::System.Data.MappingType.Element);
+                this.columnRESOURCEID = new global::System.Data.DataColumn("RESOURCEID", typeof(int), null, global::System.Data.MappingType.Element);
                 base.Columns.Add(this.columnRESOURCEID);
                 this.columnAPPT_MADE_BY = new global::System.Data.DataColumn("APPT_MADE_BY", typeof(string), null, global::System.Data.MappingType.Element);
@@ -865,5 +865,5 @@
             
             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
-            public BSDXResourceRow AddBSDXResourceRow(uint RESOURCEID, string RESOURCE_NAME, string LETTER_TEXT, string NO_SHOW_LETTER, string CLINIC_CANCELLATION_LETTER) {
+            public BSDXResourceRow AddBSDXResourceRow(int RESOURCEID, string RESOURCE_NAME, string LETTER_TEXT, string NO_SHOW_LETTER, string CLINIC_CANCELLATION_LETTER) {
                 BSDXResourceRow rowBSDXResourceRow = ((BSDXResourceRow)(this.NewRow()));
                 object[] columnValuesArray = new object[] {
@@ -901,5 +901,5 @@
             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
             private void InitClass() {
-                this.columnRESOURCEID = new global::System.Data.DataColumn("RESOURCEID", typeof(uint), null, global::System.Data.MappingType.Element);
+                this.columnRESOURCEID = new global::System.Data.DataColumn("RESOURCEID", typeof(int), null, global::System.Data.MappingType.Element);
                 base.Columns.Add(this.columnRESOURCEID);
                 this.columnRESOURCE_NAME = new global::System.Data.DataColumn("RESOURCE_NAME", typeof(string), null, global::System.Data.MappingType.Element);
@@ -1152,8 +1152,8 @@
             
             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
-            public uint RESOURCEID {
-                get {
-                    try {
-                        return ((uint)(this[this.tablePatientAppts.RESOURCEIDColumn]));
+            public int RESOURCEID {
+                get {
+                    try {
+                        return ((int)(this[this.tablePatientAppts.RESOURCEIDColumn]));
                     }
                     catch (global::System.InvalidCastException e) {
@@ -1304,8 +1304,8 @@
             public BSDXResourceRow BSDXResourceRow {
                 get {
-                    return ((BSDXResourceRow)(this.GetParentRow(this.Table.ParentRelations["BSDXResourcePatientAppts"])));
-                }
-                set {
-                    this.SetParentRow(value, this.Table.ParentRelations["BSDXResourcePatientAppts"]);
+                    return ((BSDXResourceRow)(this.GetParentRow(this.Table.ParentRelations["FK_BSDXResource_PatientAppts"])));
+                }
+                set {
+                    this.SetParentRow(value, this.Table.ParentRelations["FK_BSDXResource_PatientAppts"]);
                 }
             }
@@ -1497,7 +1497,7 @@
             
             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
-            public uint RESOURCEID {
-                get {
-                    return ((uint)(this[this.tableBSDXResource.RESOURCEIDColumn]));
+            public int RESOURCEID {
+                get {
+                    return ((int)(this[this.tableBSDXResource.RESOURCEIDColumn]));
                 }
                 set {
@@ -1609,9 +1609,9 @@
             [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
             public PatientApptsRow[] GetPatientApptsRows() {
-                if ((this.Table.ChildRelations["BSDXResourcePatientAppts"] == null)) {
+                if ((this.Table.ChildRelations["FK_BSDXResource_PatientAppts"] == null)) {
                     return new PatientApptsRow[0];
                 }
                 else {
-                    return ((PatientApptsRow[])(base.GetChildRows(this.Table.ChildRelations["BSDXResourcePatientAppts"])));
+                    return ((PatientApptsRow[])(base.GetChildRows(this.Table.ChildRelations["FK_BSDXResource_PatientAppts"])));
                 }
             }
