How to setup a lookup relationship between 2 fields in separate lists
Hi,
I have a lookup field in a list (e.g. asset list) which lookups up people from a (e.g. user list). When I lookup and associate a user from the user list in the asset list, I would like that it creates a link record within the user list.
Currently, what I do is that I need to go to the items in both lists and populate the lookup field accordingly. Can I do anything to automatically add the relationship in the second list items as relevant?
Thanks
Hi,I have a lookup field in a list (e.g. asset list) which lookups up people from a (e.g. user list). When I lookup and associate a user from the user list in the asset list, I would like that it creates a link record within the user list. Currently, what I do is that I need to go to the items in both lists and populate the lookup field accordingly. Can I do anything to automatically add the relationship in the second list items as relevant? Thanks Read More