Chapter 7

Working with Master-Detail Data Screens

WHAT YOU WILL LEARN IN THIS CHAPTER

• Understanding detail table relationships
• Grasping the essence of master-detail screens
• Understanding the role of data and layout items in master-detail screens
• Creating and using queries to filter and sort data
• Building master-detail screens manually from simple screens

Most data-centric applications work with more than one table, and those tables are related to each other. It is very common for a simple application screen to display data coming from multiple, and related, tables. For example, when you display order information, generally that screen contains an Order record (order date, shipping address, delivery method, and so on) and one or more related OrderDetail records (product, quantity, unit price, tax percentage, full price, and so on).