Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Can't determine relationships between the fields.

I have two datasheets, one containing annual costs by month and bank account, and the other one contains datailed informations about the cost on its respective bank account.   AnnualCosts          ...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Anonymous,

 

I don't think you can direct use both side table columns to create visual. In my opinion, I'd like to suggest you use bridge table column instead the original relationship columns to link those fields from different tables.

 

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

What do you mean by a bridge column in this scenario? How would one derive that?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous,

     

    I created a new column named ContaId on the bridge table.

     

    Example:

     

    Before:                                                                   Now:

    Table Conta                                                          Table Conta

    Column Conta                                                     Column Conta       Column ContaId  

    1                                                                                     1                                   1

    2                                                                                     2                                   2

    3                                                                                     3                                   3

     

     

    Than I merged the both tables (Razao and Opex) with the table Conta to get the column ContaId and created a relationship between them using the new column. 

     

    Hope it helps you.