Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Can't determine the relationship between fields when using a bridge table

 

I needed to use a bridge table to link two other tables so that I can have visuals remain blank until a selection is made in a filter(for some reason this wouldn't work with a many to many relationship). The issue is now, in another visual table that contains fields from Receivables and Notes & Actitivities, it is telling me that it can't determine the relationship between the fields. Any idea how to resolve this?

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    I'll leave this for anyone else that has a similar issue but I discovered the problem. The ReceivableID field I was using in my visual table was from one of the original tables when it needs to be from the bridge table.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I'll leave this for anyone else that has a similar issue but I discovered the problem. The ReceivableID field I was using in my visual table was from one of the original tables when it needs to be from the bridge table.