6 Replies Latest reply: Oct 25, 2013 1:09 AM by Paul Yeo RSS

    use fiueld = cust_id as link between sales table and debt table

      Hi All

       

      I have sales table and debt table , in order for me to figure out individual customer sales amount vs debt amount , i am sure i need to make use of field = cust_id from both table to create a link key.

       

      if the answer is correct. then i like to ask again :-

       

      since my sales table consist of 4 country sales. so in order to create a link key , i need to make use of :-

      filed = cust_id and field = SOURCE combine to get the link key.

       

      Paul