1. Add a flowfield in one the table that contains the fieldvalue from the other table.
A unique relation between the two tables is required.
2. Add a field to the table control that contains a variable, OnAfterGetrecord GET the fieldvalue from the other other table and put it in the variable.
Note, you wil not be able to filter on this field.
Comments
A unique relation between the two tables is required.
2. Add a field to the table control that contains a variable, OnAfterGetrecord GET the fieldvalue from the other other table and put it in the variable.
Note, you wil not be able to filter on this field.
3. Work with a temp table...