Table of Contents

Learning Objectives

 
  1. Master the use of "Default Value - Query Worksheet" to: Automatically bring up and populate default data of a subform (e.g., inspection item) based on changes to a main worksheet field (e.g., Device Type).
  2. Migrate this method to other scenarios of "multiple template data → subform details" to form a reusable configuration approach.
 

Scenario Case

 
To ensure the smooth progress of events, MEGA Company needs to regularly inspect and maintain event device and fill out device Inspection Records. Each type of device has its fixed inspection items. MEGA Company hopes to achieve the following:
 
When filling out an inspection record, after the inspector selects the device to be inspected, the app can automatically bring up the corresponding device inspection items.
 
For example: After selecting "Label Printer", the app automatically brings up the inspection items: Label Alignment Check,Print Head Cleanliness,Paper Feed Inspection,Print Quality Assessment,Ribbon Replacement Check,Print Quality Inspection and Exterior Inspection.
 

Operation Guide

 

device Inspection Item Data

 
  1. In the device Inspection Items worksheet, the inspection items for each device type have been maintained. The inspection items for Label Printer are as follows. We hope that when filling out the device Inspection Record, after selecting Label Printer, the corresponding inspection item names will be automatically brought up.
 
 

Set Default Value for Inspection Record Subform

 
When creating a device Inspection Record, after selecting the Device Type, it is necessary to query the corresponding multiple inspection items from the Inspection Details worksheet and populate them into the Inspection Details. This can be achieved by setting the default value of the subform in the device Inspection Record.
 
  1. In the device Inspection worksheet, find the subform field "Inspection Details".
 
 
  1. Set the subform's default value to query the worksheet "Device Inspection Items". When the Device Type in the device Inspection Items Worksheet matches the currently selected Device Type, the Check Item and Check Item Description from the query worksheet will be filled into the Check Item and Check Item Description fields of the subform respectively.
 
 

Implementation Effect

 
  1. When the Device Type is selected, the corresponding Check Item and Check Item Description for the device are automatically brought up.
 
 

Hands-on Practice

 
Now, click the "Open the Practice App" button in the upper right corner of the page to access the hands-on application designed for this course, and start practicing!