Lookup a Dataverse Table Column to another Column in different table?

[DuperGoon]

Hey,

I have multiple tables, some that have some information needed for a different table. I was thinking of using, lets say column A  & B in Table One .I want to do a lookup to link Table One: Column A with Table 2 (different table): Column B. 

So the idea is that Table 2: Column B has the master list, while our TABLE ONE is tied to that specific column. Right now I can only tie to a table and use the primary column of data. Any suggestions? 

[dpoggemann · Accepted solution]

Hi @DuperGoon ,

Hopefully I understand what you are saying here...  Please review and let me know.

1. You can have a column on Table A that is a Lookup to the Primary Name column on Table B.  This is the only way in Dataverse to link the tables is through the Lookup field which will relate to the Primary Name field on that table (behind the scenes it is linked by the GUID to that table of course)...
2. You can add additional columns to table A that can be calculated columns or formula columns that can reference additional fields from table B that you are connected to.  

Option that doesn't copy data to Table A from Table B

1. You can setup your views for Table A to show columns from Table B (under Related when adding fields to table A views
2. You can setup a Quick View form on Table A that will show fields from Table B on Table A's form (https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/create-edit-quick-view-forms)