2 Replies Latest reply: Jul 17, 2013 10:00 AM by camilof1 RSS

    Circular Reference avoidance  - Two DBs

    Bradley Coyne

      Hi i have the following scenario.

       

      i have two DBs that i am joining together.

       

      DB1 Carries Project Information

      DB2 Carries pricing information specific for customers.

       

      Pricing information from DB1 is to be passed through Field ArtNo, which ultimately carriesa unique price depending on customer.

       

      in the model below i need to attach the ArtNo from DB1 (ex table TimeCode) to DB2 (ex table Jeeves Price) in order to get the right price for the right customer on the project id.

       

      however if i do that i end up in circular refernce.

       

      any tips?

       

      Best,

      Brad

       

       

       

      Datamodel.jpg

      J