Cross-Table Field

1. Field Introduction

The cross-table field control is used in conjunction with linked records. A cross-table field can reference a specific field within a linked record. If you need real-time synchronization of business data, you can use a cross-table field to sync changes in linked data in real-time.

The type of field a cross-table field references will have the properties of that field type. For example, if it references an option field, it can be displayed as an option; if it references an attachment, it can be previewed/downloaded; if it's a number type, it can be used for calculations and statistics when storing data.

2. Cross-Table Field Linked Records

The linked record set for a cross-table field can only be bound for single-record use.

3. Cross-Table Field Types

Type 1: Display Only Suitable for scenarios where only field display is needed. Data is fetched in real-time only when loading records and is not used for statistics, calculations, etc.

Type 2: Data Storage Stores data in the current table and keeps it synchronized. After storage, the cross-table field can be used for worksheet search, filtering, sorting, statistics, or used by formula or text combination fields. Note: 1. There is a certain delay between the stored data and the actual data; 2. After the display field data changes, a maximum of 1000 related rows can be updated. Therefore, this method is suitable for scenarios where the display field's value does not change, or although it changes, the number of linked records is relatively small (not exceeding 1000 rows).

4. Reference Effect

Example 1: Reference the "Specification" information from the "Product Service Items" to the "Order Details" table. When a product service item is selected, the specification content is automatically filled in.

Example 2: In the "Order Details" form, add a linked record for "Product Service Items" and set the cross-table field "Official Unit Price (Yuan)" to store data. It can then be used by the formula field to automatically calculate the product result.