Forum Discussion

donovanm's avatar
donovanm
Frequent Visitor
1 year ago
Solved

Calculating Values By Contract By Country From Multiple Tables

Hi,    I am trying to produce a table that will report the number of contracts that my company has in each country by reference.  This is complicated slightly by the the fact that I am using multip...
Need Help
  • mussaenda's avatar
    mussaenda
    1 year ago

    You can do a relationship by using the two columns country and company reference

FreemanZ's avatar
FreemanZ
Super User
1 year ago

hi donovanm ,

 

how are Table1 and Table2 related?

donovanm's avatar
donovanm
Frequent Visitor
1 year ago

Hi,

 

I have a relationship on the company reference.

 

Rgds,

 

 

  • mussaenda's avatar
    mussaenda
    Community Champion
    1 year ago

    You can do a relationship by using the two columns country and company reference