Setup
- In a first table (S32), the user completes a column with variables
- In a 2 table it imports rows that use one of these variables for a formula
- Example in steps
1) Area - m² - 100
2) Length - m - 25
II) A data table linked to table 2: List of items with each time the number of the criterion to be taken into account (either 1 for surface or 2 for length)
III) A table S32 which points to the table (II) and which contains a column S33 which will be updated when importing rows with the criterion number mentioned
IV) During import, the S33 will be replaced by the value of the selected row (100 for the surface, 25 for the length)
Setup 2
- Linked database: A column specifying per line the row to take into account of the 1st table (F32)
- 2nd table: in the column with an S33, the number of the field of the 1st table as well as the number of the column to be taken into account
- Structure and freeze the table of data from Table 1
- Do not delete one of the rows of the 1st table afterwards because the sequence of numbers would change
- This format is reserved only for the columns of an S32 and is therefore not available for an F32 or for a field.