One of the great features of LightSwitch is that it lets you connect to and manipulate data inside of SharePoint. Data can come from any of the built in SharePoint lists like Tasks or Calendar or it can come from custom lists that you create in SharePoint.
LightSwitch provides the ability to connect to multiple data sources like external databases and SharePoint and relate them together. However when you want to present data from multiple data sources on the same screen you need to tell LightSwitch the order in which you want to save this data.
See link below for a video presentation on how to achieve this:
LightSwitch is the new way to go…. reduced development time, reduced effort – maximized results!