Forum Discussion

karinafreitass's avatar
karinafreitass
Icon for Helper III rankHelper 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 ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    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

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

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