Create relationship between 2 tables (Invoice Header and Invoice Details)

[ams123]

I am trying to create a relationship between Tests linked to Requirements.  I also have a working relationship between Systems and Requiremets.

Trouble is the Requirements can be tested by multiple Tests with some text so the cell is formated like shown.

Test data below.

If I don't slice by System everything is fine, showing total Requirements and Pass/Fail status for all Tests.

When I slice by a System I would like to see the test status for that system only but that does not work.

[v-jiascu-msft]

Hi @ams123,

Did it help? 

Best Regards,

Dale

[ams123]

After trying out you solution I better understand how that will fix my issue.  Thanks,

[ams123]

Yup I appreciate the confirmation that I cannot do what I need to do in this case.

[v-jiascu-msft · Accepted solution]

Hi @ams123,

I'm afraid you can't create a relationship like that. There are no same values. Though you can create a relationship, that won't work. Let's take your scenario as an example, there aren't any values in the Tests because there are no ids "200: foo" and "204: foo".

The solution could be as shown in the snapshot.

Best Regards,

Dale