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
Solved! Go to Solution.
Hi @peterharket ,
Sorry, you only get that main column. There are some things you can do though...
Hi @peterharket ,
Sorry, you only get that main column. There are some things you can do though...
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!
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?
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.