Can't determine relationship between fields - any way to show on same table visual

[rjspereira]

Hi, I have 3 tables, like this example:

the main table has a one to many relationship with the Entity and also with the Country table.

I am trying to have a table visual something like this:

Visual Table
id	type	status	Entity	Country
1	contract	Pending	Visa	France
1	contract	Pending	HTC	Spain
1	contract	Pending	BFN

The problem is when i am adding the fields to the table, as soon as i add the field country, when i already have the Entity, i receive the error message: Can't determine relationship between fields 

I know that the country France or Spain, does not have a direct relation to any of those Entities, only to the main id.

Is there anyway to be able to have both fields in the same table??

Thanks.

[rjspereira]

The question is that there is no relation between country and Entity. The only relation that exists is with document id =1 having multiple entities (3 in this case) and with 2 countries.

It apears that i have no option to have a visual table that permits extract to excel this information of multiple fields that have relation with document id but not among them.

[audreygerred]

What I am asking is, how do you know which Entity goes to each Country? Like in that table you made, you had certain Entities aligned to countries - how do you know which go together?

[rjspereira]

i dont know, because, is just a list of entities and a list of countries per id. the only way that i have accomplished is to concatenate the list of entities and the list of countries and present that in a table with single row for id=1.

id	type	status	Entity	Country
1	contract	Pending	Visa; HTC; BFN	France; Spain

i was wondering if existed any other way of listing in as many rows as the number of entities or countries.

[audreygerred]

Right now, in your table that you would like to have, it looks like Visa Entity is for France and HTC is for Spain.... how do you know that? Once we figure out how that is determined to begin with we can brainstorm the best way to tackle it.