Normalized Resources DB Location w/Foreign Keys

[Kyle]

I'm having an issues refercing my resources through the scheduler control. It seems that in all of the examples the 'resourceID' is located directly on the appointment table with a foreign key(lets say to rooms or people). Our datamodel is a little more normalized in that we have a 'ApptResources' href table that serves as a one-to-many for each appointment and then in turn has a foreign key reference to our 'Users' table. Is it possible to have the resources datasource point explicitly at our 'ApptResources' table as opposed to the appointments table? BTW...our 'ApptResources' table also has a foreign key to the appoinments table.

Thanks
Kyle

[Veronica]

Hi Kyle,

I think that this is possible. The only thing to think of is the way the resources are selected from the database and the update/insert of appointments. I'll try to prepare a sample project for you to test this scenario.

Please note that we are in the process of working for the upcomming Beta. I'll contact you as soon as possible.

Thank you for your patience!

All the best,
Veronica Milcheva
the Telerik team