Dataverse see two tables

[_Judy_]

Hello, Could I ask if I want to see two dataverse table join togeter.

How to do it?

That is my design.

Table A 

key	Course_Type
0001	A
0002	B

Table B 

TableA_key	Course_Name	Course_Type_lookUP
0001	Music
0001	Art
0001	P.E.
0002	Cook

I want to see  : 

TableA_key	Course_Name	Course_Type
0001	Music	A
0001	Art	A
0002	P.E.	B
0001	Cook	A

Thanks.

[dpoggemann · Accepted solution]

Hi @_Judy_ ,

1. Create the table A for your Course Types in Dataverse
2. Create Table B with your Courses and you should add a column to this table as a Lookup and then point this lookup to Table A (course types)

At this point you will have created a 1:N relationship from Course Type (table A) to Course (table B).  You can add a tab in your Course Type form to show the list of all the related Courses (using Subgrid) or even add to the same tab as well.

[_Judy_]

Thank you dpoggemann. 

: )