How to Use WPS One-Way Linked Fields on Windows

Use One-Way Linked Fields with 3 how-to topics, including creating a field, linking records manually, and setting automatic matching; choose a topic from the index and follow the entry path and steps.

How-to Index

How-to Guide

1. Create a Field

Entry path: Click the + button on the right side of the table header, then choose Link Current Table Field or Link Other Table Field

1. Click the + button on the right side of the table header.
2. In the field type list, select Link Current Table Field or Link Other Table Field.
3. Enter a field name.
4. Click OK to finish creating the field.

Success Criteria

• Interface result: The new linked field appears in the table header.
• What you can do next: You can open field settings and continue configuring linking rules.

Tips While Using

• Common mistake: Choosing the wrong field type affects the later linking direction, so confirm whether you need the current table or another table before creating it.

2. Link Records Manually

Entry path: Right-click the field title, select Field Settings, then choose the target table

1. Right-click the field title and select Field Settings.
2. Choose the target table you want to link.
3. Set the linking method to Manual Linking.
4. Adjust the linked record range and whether multiple records can be linked.
5. Click OK to save the settings.
6. Click inside a cell and select the data record to link.

Success Criteria

• Interface result: The selected linked record appears in the cell.
• What you can do next: You can continue editing linked records or adjusting field settings.

Tips While Using

• Common mistake: If the target table is not selected first, you may not be able to choose the correct linked records later.

3. Set Automatic Matching for Linked Records

Entry path: Right-click the field title, select Field Settings, choose the target table, then select Automatic Matching

1. Right-click the field title and select Field Settings.
2. Choose the target table you want to link.
3. Set the linking method to Automatic Matching.
4. Set the matching conditions.
5. Click OK to save the settings.
6. Check whether eligible records have been linked automatically.

Success Criteria

• Interface result: Matching records display linked results automatically.
• What you can do next: You can continue adjusting the matching conditions and save again.

Tips While Using

• Common mistake: If the matching conditions are incomplete, the result may not match your expectation.
• Environment note: Before using automatic matching, confirm that the target table contains records that can be matched.