0 Replies Latest reply: Sep 28, 2012 5:47 PM by Bradley Coyne RSS

    Connecting tables and avoiding circular reference

    Bradley Coyne
      Hi All i need help with the following;
      i am putting together two source systems thorugh the following logic.
      i aim to derive a unique customer price for each timecode connected a relative artno which in turn is connected to a project number, with a specific customer attached to that project.
      Table 1: PriceList - (Unique Customer Table that is linked to individual pricing scheme through use of an article number) - DB1
      Table 2 links to the transactional table.  (see db model pic attached for logic description)
      CustomerNrartnrpris(price)
      1501020
      1400030
      2501040
      Table 2: TimeCode - Table that connects to the transactional table and tells it which artno is been used in the project. - DB2
      TimeCodeIdtidkodartno
      20consulting5010
      35running4000
      40snoozing3000
      any modelling tips on how to create this relationship without running into circualr refernce and recieving the right price to the right project project number?
      //best
      Bradley