QWS provides a comprehensive set of tools to make SharePoint data relational. It will help you connect, relate and manage data with advanced relational constructs. It provides business users with the power to create advanced cross site systems with a simple ‘drag, drop and configure’ interface. It includes a number of webparts that allow business user to easily build parent–child relationships, cross site lookups, auto filling, dependent lists, flow control and persistent filtering. This is a must have for the development of rich applications in SharePoint.
Solve critical pain points without custom coding: Being able to relate data is a common capability in any database or Business Intelligence system. Relating data has been a key tool to turn raw data into relevant meaningful information. In real terms SharePoint has no capability to relate data across sites, sites collections, web applications, or virtual servers.
QWS will allow SharePoint designers to define a primary key field and foreign key field in the lists. You can also replicate some fields from the parent list in the child lists so that those fields are available to be displayed and searched.