Forum Discussion

EMGI's avatar
EMGI
Frequent Visitor
8 years ago
Solved

Many to Many Relationship

Hey everybody,   i need your help. Let me explain my problem: I have 2 tables which will be updated/imported every month with a new csv-File.   In the table "calculated table" i have different, ...
Need Help
  • EMGI's avatar
    EMGI
    8 years ago

    Hi everbody,

     

    got the solution. First problem was to choose the wrong "offerID"-column to get a relationship.

    I created a unique ID in the Pricelist concatenate with OfferID + Month(ValidFromDate) + Year(ValidFromDate).

     

    Thanks for replies and help.

miltenburger's avatar
miltenburger
Helper V
8 years ago

Hi EMGI,

 

First thing i'm thinking of to tackle this problem:

Make a calculated column in your calculated table where you put the price.

So based on the start date in calculated table you create a column where you put your price for the specific customer for a specific orderId.

 

You get me?

  • EMGI's avatar
    EMGI
    Frequent Visitor
    8 years ago

    Thanks for fast reply, but i didn't get you.

    How can I set up a calculated column with the price if the relationship don't exists???

    • miltenburger's avatar
      miltenburger
      Helper V
      8 years ago

      Ah sorry,

      I thought you already had the relationship.

       

      Then you have to create a 'link table'. What you probably need in this link table:

      - OrderId

      - PartnerId

      - Startdate

       

      All defined as primary key. Then link to your other tables. Then your many-to-many relationship becomes one-to-many and one-to-many

      • EMGI's avatar
        EMGI
        Frequent Visitor
        8 years ago

        My problem is how to create a link table with the values of the other two tables?

         

        Which columns i need in the link table to get going on with the calculation?

         

        I think the table has to be dynamically updated every time a new OfferID and a new price is inserted, or am i wrong?