Normalized Resources DB Location w/Foreign Keys

2 posts, 0 answers
  1. Kyle
    Kyle avatar
    1 posts
    Member since:
    May 2011

    Posted 14 Jun 2011 Link to this post

    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
  2. Veronica
    Admin
    Veronica avatar
    1213 posts

    Posted 17 Jun 2011 Link to this post

    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

    Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.

Back to Top