Add multiple columns from lookup table

[peterharket]

Hi!

Is there a way to add other columns besides the "main" ID column from another table when using the lookup column function?

I know that in Sharepoint, you can lookup another table, and then select which columns in addition to the "main" ID column you would like to bring back to your original table.

Peter 

[dpoggemann · Accepted solution]

Hi @peterharket ,

Sorry, you only get that main column.  There are some things you can do though...

1. Define views that will show columns from the lookup table.  When you create your view you can choose "Related" and then select additional columns from the lookup table
2. Similar to #1, you can define a Quick View form for your lookup table and then in your main form you can add a section and choose to add the Quick View form from your lookup entity.  This will display the fields selected from that table.

[peterharket]

The view did it for me! Guess it doesn't really make sense to physically add the data from another table to the table in question, so a view that joins the relevant data only when needed makes good sense!

[peterharket]

One thing though:

If I add a related column to a view (let's say product name), and then a user adds data (or rather selects a product name from the lookup), where will the data entered for the product name be stored?

[dpoggemann]

Hi @peterharket,

This is only a "view" into those fields and all the data is stored on the Product table, you are just pulling those fields into your view.