Joins Mapping overview

When querying LSF data tables, you can include two related tables with data relationships. For example, one row of data from table A has a matching row in table B. Alternatively, one row of data from table A might have multiple rows in table B, such as how many purchase order lines fall under one purchase order. When adding two related tables in the query, you can encounter an error that results in multiple duplicated rows of data. This is because Infor Lawson Add-ins cannot establish a data relationship between the two related tables you included in the query.

In this case, you can use the Joins Mapping feature introduced in 10.0.9.162. In the Joins Mapping tab found in Query Wizard, two drop-down fields and one data grid are displayed. In the drop-down fields, you can select which two related table fields are mapped to each other. For example, when mapping POLINE and MMDIST tables, you can map the POLINE.COMPANY field to the MMDIST.COMPANY field, since they refer to the same Company data. You can create multiple mappings between two related tables, spanning multiple fields, to establish the full extent of their data relationship to each other.

Note: Creating join maps requires basic knowledge of Infor Lawson databases. Use this feature only when recommended, for the express purpose of removing duplicated data from the output of Query Wizard. Past saved queries can still function as before even without creating these join maps.

See Creating join maps.