One-to-many relation not working as expected

[NickolajJessen]

I have linked two tables together without problem. A table with Project & sales amount and a filtering table, that contains the projects_ID and a date.

Project_ID and Ledgeraccount are the same.

There is a specifik project, project 978400-06-03, that are in both tables, but somehow doesn't match... (Marked blue below)
A very similar project 978400-06-02, that are also in both tables, are matched without a problem (Marked green below)

What did i do wrong?

[v-piga-msft · Accepted solution]

Hi @NickolajJessen,

By my tests with two tables similar to yours, it seems that everything works as expected.

Here is the output.

It seems that your relationship is not active, please active it and try again.

If you still need help, please share some data sample which could reproduce your scenario so that we could help further on it.

Best  Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @NickolajJessen,

By my tests with two tables similar to yours, it seems that everything works as expected.

Here is the output.

It seems that your relationship is not active, please active it and try again.

If you still need help, please share some data sample which could reproduce your scenario so that we could help further on it.

Best  Regards,

Cherry

[NickolajJessen · Accepted solution]

Hi @v-piga-msft

Thank you for your response.

From your example i realisered that my relasionship was actually inactive. Indicated by a dotted line in stead of a full line.
This was caused by some other tables having bi-directional relationships (I think)
I revised the bi-directionaltables and activated the relationship between the two tables in question and now it's working as expected!

[v-piga-msft]

Hi @NickolajJessen,

It seems that you have solved your problem.

Please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

Best Regards,

Cherry