Hi, I am having trouble saving appointments on which I have changed the header colour/color. I am using an SQL Server database to store my data and am writing in VB.Net.

The error I get is "The delete statement conflicts with the Reference constraint " Item_FK03". The conflict occurred in database "MySQL_Database", table"dbo.item", column 'Style'.

I believe the error occurs due to there being no item in the Style Table to match the change colour in the header.? My question is, how can I change the header colour based on the resource assigned to that resource and the save the item?

Is there another way of doing this like assign a style to a specific resource so every time that resource is assigned to an appointment it is automatically said colour.

Thanks in advance,
Tim.

Thanks for the reply Meppy. Have read a number of your posts and your knowladge of not only this control but programming in general is unbelievable!!

Anyway....
These two tables are set up with the same fields as the standard "planner" database with a few additional fields for information i require. the relationship is from Parent table "Style"/"Key" to Child Table "Item"/"Style" set to "Relation Only"..No consttraints or Rules.


Is that the information you were requesting.

I have discovered it is not only when I change the colour of the header. It when I create an appointment via the form I have created. When creating an Appointment via code, do I have to specify a style?

Here is the Stack Trace...

System.Data.SqlClient.SqlException
Message=The DELETE statement conflicted with the REFERENCE constraint "Item_FK03". The conflict occurred in database "DashboardPlannerSQL1", table "dbo.Item", column 'Style'.
The statement has been terminated.
Source=.Net SqlClient Data Provider
StackTrace:
   at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
   at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable)
   at System.Data.Common.DbDataAdapter.Update(DataSet dataSet)
   at MindFusion.Scheduling.DataBinding.x8db18c2080b4ae64.x836093ae8ca8dd2e(Boolean xd441e330aca0adbe)
   at MindFusion.Scheduling.DataBinding.xa7e178e5abda1bf4.x3967b919ae7ea836(Boolean xd441e330aca0adbe)
   at MindFusion.Scheduling.WinForms.Calendar.SaveToDataSource(Component reminderTableAdapter, Component styleTableAdapter, Component customBrushesTableAdapter, Component contactTableAdapter, Component locationTableAdapter, Component resourceTableAdapter, Component taskTableAdapter, Component itemTableAdapter, Component itemContactsTableAdapter, Component itemResourcesTableAdapter, Component recurrenceTableAdapter, Component recurrenceExceptionTableAdapter, Component recurrenceExceptionsTableAdapter)
   at WindowsApplication1.frmDashboard.SaveToolStripButton_Click(Object sender, EventArgs e) in C:\Users\valued customer\Documents\Visual Studio 2012\Projects\ProjectDashboard\ProjectDashboard\Dashboard.vb:line 98Int32 UpdatedRowStatusErrors(System.Data.Common.RowUpdatedEventArgs, BatchCommandInfo[], Int32)
InnerException:

Hi Meppy,
I have it working. I created my database from scratch and it works fine now. I still can not see the slightest difference between the two databases but the new one works!!

Thanks for your assistance.