Single-Record Linkage of Subform

Introduction

Case Introduction

This case will introduce how to retrieve a certain record from a subform in another form to the current form with Data Linkage.

Application Scenario(s)

How to Design

1. Add Number fields as auxiliary fields in the two forms.

2. Use the subform as the data source of an aggregate table, and set the auxiliary fields as measures to differentiate subform records.

3. Set a single-record linkage for the subform in the form and use the auxiliary fields to set conditions and call the value from the aggregate table.

Preview

For example, in product model registration and stock-in registration:

1. Record the product model details in the Product Model Registration form.

2. When filling in the stock-in information in the Stock-in Registration form, the product model details will be displayed according to the product you selected.

Setting Procedure

Take an example of product model registration and stock-in registration.

Designing Forms

1. Create a Product Model Registration form and add the following fields:

2. Create a Stock-in Registration form and add the following fields:

Creating an Aggregate Table

1. Go to App Management > Aggregate Tables, and click New Aggregate Table.

2. Name the aggregate table as Single-Record Linkage, click Data Source > Single Form, select Product Model Registration from the drop-down list, and click OK to save the settings.

3. For the Row Header of the aggregate table, add the Product Name and Quality Level subfields from the Product Model Registration form.

4. For the Measure of the aggregate table, set the Auxiliary Field to Number – Auxiliary Field. The Number – Auxiliary Field is from the Product Model Registration form.

After the settings, click Save.

Setting Data Linkage

1. Select the Product Name field of the Stock-in Registration form, go to Field Properties > Option, then select Data Linkage.

2. Click Data Linkage Settings and make the following settings:

After the settings, click OK.

3. Similarly, set the data linkage for the Quality Level field：

Select the Auxiliary Field field of the linked form and the Number – Auxiliary Field field of the current form, then set the relationship as equals.

Select the Product Model Registration.Product Name field of the linked form and the Product Name field of the current form, then set the relationship as equals.

After the settings, click OK.

Setting Field Permissions

For the Number – Auxiliary Fields in the Stock-in Registration form and the Product Model Registration form, go to Field Properties > Field Permissions, and disable the View permission.