Forum Discussion
Building relationship between SharePoint lists (Lookups or store the ID using number field)
I have 3 SharePoint custom lists:- 1) Direction 2) Street 3) Location where each Direction item should be linked to one street and one location. There are 2 ways to build the relation...
Hi John,
Which based column you used for sharepoint lookup column ? the ID or title?
In my side, i mostly using sharepoint relationship for customer needs and never get any issues with that.
Once the relationship is done from the ID as primary, of course i add columns i want to see in the parent list but when data changed from one of these column in relationship, it's updated as the relation is done from ID.
Rgds,
Valentin
Which based column you used for sharepoint lookup column ? the ID or title?
In my side, i mostly using sharepoint relationship for customer needs and never get any issues with that.
Once the relationship is done from the ID as primary, of course i add columns i want to see in the parent list but when data changed from one of these column in relationship, it's updated as the relation is done from ID.
Rgds,
Valentin
vlecerf so you mean you use Lookup fields? and not the appraoch of storing the ID of the parent list in a number field? and you are happy with it?
