2 Replies Latest reply: Dec 11, 2012 12:02 PM by Sergejs Kazakevics RSS

    The best way of linking two tables

    Sergejs Kazakevics

      Hello,

       

      I've got a question about what's the best way of linking two tables like this:

       

      Table 1 - Sales:

      CR_IDORD_IDQTY
      1234561
      1254565
      1275677

      Table 2- Options

      CR_IDORD_IDOPT
      123456a
      123456b
      123456c
      125456a
      127567b

      Is this the best solution to link them on CR_ID if people want to report on OPT field? For example, they want to select one or combination of options to see the total QTY or count of orders with this option or particulatr combimation of options.

       

      Thank you in advace,

      ~Serg