Forum Discussion

karinafreitass's avatar
karinafreitass
Helper III
5 years ago
Solved

Relationship between tables

Hi Guys,

Please, 

What function could I use to relate the flançamento table and dimCargos?

I have the column of values "Debito" in the table "fLançamento", and I would like to filter to add these values in the table "dimCargo".

Grata,

Karina

  • Do one's ID values match those in the other table? If so, you can use TREATAS to pass a filter between them unrelatedly, or you can use the USERELATIONSHIP function once you perform an inactive relationship between those tables.

    Best regards

    Pat

2 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee

    Do one's ID values match those in the other table? If so, you can use TREATAS to pass a filter between them unrelatedly, or you can use the USERELATIONSHIP function once you perform an inactive relationship between those tables.

    Best regards

    Pat