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

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.