Creating a Three-Level Master-Detail Page

Labels
AJAX(112) App Studio(7) Apple(1) Application Builder(245) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcode(2) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(12) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(177) Device(1) DotNetNuke(12) EASE(20) Email(6) Features(101) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(5) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(18) OAuth(9) OAuth Scopes(1) OAuth2(13) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(11) PKCE(2) Postgre SQL(1) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(183) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(81) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(2) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(338) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Archive
Blog
Saturday, September 1, 2012PrintSubscribe
Creating a Three-Level Master-Detail Page

Let’s create a page with a three-level master-detail relationship between Customers, Orders, and Order Details controllers.

Three-level master-detail relationship between Customers, Orders, and Order Details tables.

Creating the Page

Start the Project Designer. On the toolbar of the Project Explorer, click on the New Page icon.

New Page icon on the Project Explorer toolbar.

Enter “OrderManager” in the page Name and press OK to create a new page.

Property Value
Name OrderManager

The Order Manager page will be added to the bottom of the list of pages in the Project Explorer. Drag Order Manager node to the right side of Home node to place it after the page.

Dropping Order Manager page node on the right side of Home node.     Order Manager page is placed after Home page.

Switch to the Controllers tab in the Project Explorer. While holding Ctrl, select the controllers in the following order: Customers, Orders, OrderDetails. Right-click on OrderDetails, and press Copy.

Copy context menu option on OrderDetails controller node in the Project Explorer.

Switch back to the Pages tab. Right-click on Order Manager page node, and press Paste option. The controllers will be instantiated as data views in separate containers on the page.

Paste context menu option on the Order Manager page node in the Project Explorer.     Views for Customers, Orders, and Order Details controllers have been added to the Order Manager page.

Right-click on Order Manager page node, and press View in Browser.

'View in Browser' context menu option for a page node will generate the project and open the relevant page in the default browser.

Navigate to the Order Manager page. Three views will be available on the page, but they do not have any master-detail relationships established between them. The three data views are completely independent from each other.

Order Manager page with three unconnected data views. Filters have been applied to reduce the size of the image.

Establishing Master-Detail Relationships

Switch back to the Project Designer. In the Project Explorer, drag the data field node Order Manager / c102 / view2 / grid1 / CustomerID onto the view node Order Manager / c101 / view1. This will configure a master-detail relationship between view2 and view1, with CustomerID as the filter field.

Dragging CustomerID data field node onto 'view1' data view node.     'View2' has been configured as a detail of the master view 'view1'.

Next, drag the data field node Order Manager / c103 / view3 / grid1 / OrderID and drop it onto view node Order Manager / c102 / view2.

Dragging OrderID data field node onto 'view2' data view node.     'View3' has been configured as a detail of the master view 'view2'.

On the toolbar, press Browse.

Only the Customers data view is now visible on the Order Manager page.

Order Manager page with only the list of customers displayed.

Select a record from the list of customers, and orders related to the selection will appear in a data view underneath.

When a customer has been selected, a list of order will appear.

Select an order, and order details for that order will be displayed.

When an order is also selected, a list of relevant order details will be displayed.

Select a child order detail. The record will be displayed in a modal form.

Opening an Order Detail record will display fields in a modal form.

If a master data view enters “New” mode, the child data views will automatically become hidden.

For example, if a new customer is created, the data views Orders and Order Details will be invisible. If a new order is created, only Order Details data view will disappear.

When a new customer is created, Orders and Order Details views are hidden.

Note that the field being used to filter must have Allow Query-by-Example enabled.