Forum Discussion
Create relationship between 2 tables (Invoice Header and Invoice Details)
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.
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
4 Replies
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
