Relation between tables .

[Anonymous]

Hi guys,

Firstly i would like to thank you for the help you have given to me here is this community.

There is an issue i want to discuss it with you:

1- I have three table (person and names and ages) in person table there are two fields which are name and age and the two other tables are linked to Person table using Person ID.

2-In Data Model Viewer in Field section if i choose the first table (Person) it will show me all field of this table (name and age) what i want to do is if i choose name it lists all name inside table name at a specific Person ID .

I hope i could explained clearly .

rwunderlich‌

swuehl‌

stalwar1‌

omarbensalem‌

[OmarBenSalem]

Not really; could u explain with some sample values please?
Maybe 3 lines of each table, and when you select name from table person, what do u want to show?

[neha_shirsath]

Not understood what exactly you want to achieve, in Data Model viewer what exactly you want to see?

[Anonymous]

i changed the last example

Here i have two tables :

1-Organization :

2-Names :

What i want to do inside Data Model Viewer is:

If i select the Organization table all its columns will be shown which are (companynames,schoolnames,bakreynames)

after that if i select schoolnames all records from Names table which have ID = (2) will be shown which are (alsaade ,poin)

omarbensalem‌

[OmarBenSalem]

Fist of all, the 2 table should be linked;

rename ID as PersonID

second of all, u can't see that in the data model viewer; but rather create a table in the sheet, and put all the dimensions measures u want to show; create some filter and u'll have what u're looking for

[neha_shirsath]

I think this is not possible, as data model viewer is just to show the linking of tables not what the individual fields data details.

[Anonymous]

Sorry : there was a mistake in my previous comment.

i changed the last example

Here i have two tables :

1-Organization :

2-Names :

What i want to do inside Data Model Viewer is:

If i select the Organization table all its columns will be shown which are (companynames,schoolnames,bakreynames)

after that if i select schoolnames all records from Names table which have ID = (2) will be shown which are (alsaade ,poin)

[neha_shirsath]

What is the linking field for Organization and Names table?

First understand the primary key between both tables.

[Anonymous]

Dear .

Simply i want to view details for the specific field (which are exists in another table ) inside data viewer when i drag and drop that field.

[neha_shirsath]

This is not possible in data model viewer. You can try this on front end.