This is an abbreviated view of my linker table with two tables that join to it.
| LINKER TABLE |
| SALES|KEY | DEPARTMENT|KEY | CUSTOMER|KEY | PRODUCER|KEY |
| SALES1 | SALES | ABC Corp. | (null) |
| (null) | SALES | ABC Corp. | PROD1 |
| | | |
| PRODUCER TABLE |
| PRODUCER|KEY | Percentage | | |
| PROD1 | 0.9 | |
| | | | |
| SALES TABLE |
| SALES|KEY | Commission | | |
| SALES1 | 10000 | |
| | | | |
With the structure above is it possible to write an expression that takes the "Percentage" multiplied by the "Commission" based on the Department|Key and the Custiomer|Key being the same....even though there are nulls in the Producer|Key and Sales|Key? Or is it impossible to correlate the values because there is no true relationship between the Producer table and the Sales table?
