1 Reply Latest reply: Oct 5, 2013 12:18 PM by Sadha Chilukoori RSS

    Linking table

    Steve Zagzebski

      This is an abbreviated view of my linker table with two tables that join to it.

      LINKER TABLE
      SALES|KEYDEPARTMENT|KEYCUSTOMER|KEYPRODUCER|KEY
      SALES1SALESABC Corp.(null)
      (null)SALESABC Corp.PROD1
      PRODUCER TABLE
      PRODUCER|KEYPercentage
      PROD10.9
      SALES TABLE
      SALES|KEYCommission
      SALES110000

       

      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?