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
