0 Replies Latest reply: Feb 26, 2015 4:12 AM by Andrew Weekes RSS

    Issue Mapping Two Sets of Data

      Hi Folks,

       

      We were wondering if someone could help us with this. We have an issue mapping two sets of data to our sales records.

       

      Profit Customer linked

      Profit Non Customer Linked

      Sales

      Product Code

      Product Code

      Order Date

      Order Date

      Order Date

      Cust Code

      Profit Amount

      Profit Amount

      Product Code

      Arrange No

      Arrange No

      Sales Value

      Cust Code

       

      Sales Qty

       

       

      RSP

       

      Essentially both profit tables contain the same data except Profit Customer linked contains a customer code.


      When we put both into the same table, we had two keys originally (key 1 - Cust Code, p-code and o-date / key 2 – Cust Code, p-code), however we had issues with two keys in one table linking to two keys on another table.

       

      When we had these in two tables (based on the same keys from above) - When we selected one arrange number from one table it would drill down to specific dates and products in the sales table which would then pick up values on the second table.

      When we merged the two tables into the sales tables, when we selected a date and product the correct figures appeared however when we selected an arrange number the field such as RSP are not appearing which are actually needed.

       

      Thanks in advance.

      Andy