Schedular with a database

[Max]

Hi,

I created the following table inside my database:

CREATE TABLE [Rooms]

(

   [ID]        INT                IDENTITY(1,1)   NOT NULL,

   [RoomName]  nvarchar(255)                    NOT NULL,

   CONSTRAINT [PK_Rooms] PRIMARY KEY CLUSTERED

   ([ID])

)

GO

CREATE TABLE [Users]

(

   [ID]        INT                NOT NULL,

   [UserName]  nvarchar(255)      NOT NULL,



   CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED

   ([ID])

)

GO



CREATE TABLE [dbo].[Appointments]  

(  

   [ID]                    INT IDENTITY(1,1)   NOT NULL,  

   [Subject]               nvarchar(255)       NOT NULL,  

   [Start]                 datetime            NOT NULL,  

   [End]                   datetime            NOT NULL,

   [RoomID]                INT                 NULL,

   [UserID]                INT                 NULL,

   [RecurrenceRule]        nvarchar(1024)      NULL,  

   [RecurrenceParentID]    INT                 NULL,  

   [Annotations]           nvarchar(50)        NULL,  



   CONSTRAINT [PK_Appointments] PRIMARY KEY CLUSTERED   

       ([ID]),  



   CONSTRAINT [FK_Appointments_ParentAppointments] FOREIGN KEY  

       ([RecurrenceParentID])  

   REFERENCES  

       [Appointments] ([ID]),



   CONSTRAINT [FK_Appointments_Rooms] FOREIGN KEY  

       ([RoomID])  

   REFERENCES  

       [Rooms] ([ID]),



   CONSTRAINT [FK_Appointments_Users] FOREIGN KEY  

       ([UserID])  

   REFERENCES  

       [Users] ([ID])  

)  

Then, I created a SQLdatasource to access the Appointments table. The connexion is succeful.
In the smart tag of the controler, I defined the correct field for key, start time, end time, ect...

I also created a second SQLdatasource to access the Users table.

Then I did this :

Select the RadScheduler in the designer, and click the ellipsis button on the ResourceTypes property in the property pane.

In the Resource Type Collection Editor, add a new resource type and configure it to bind to the second SQLDataSource:

Problem is: I can't add any events in the scheduler. When I double click on the scheduler, I see the box to create a new event, but when i click on the icon to create the event, it just disappear...

What have I done wrong ?

Thx a lot for your help

Edited:
I didn't check the box generate update insert delete while creating the datasource...