January 14, 2019 at 03:42 #23497
I’ve got the vLookup working fine from a Parent to create a new Child item, works great.
But if a user opens a new form directly from the Child list, can they attach it to the existing Parent item, like a reversed vLookup?
Or would a different plugin work, cascading drop-down perhaps?
Thanks for your time,
January 14, 2019 at 20:10 #23508
If your parent list doesn’t grow over 5000 items you could use a lookup form the child list to the parent list as “connection” for the vLookup. This way you can either add from the parent, or go directly to the child list and select the parent in the normal lookup column.
January 14, 2019 at 23:47 #23513
Not sure what you mean “normal Lookup column” do you mean the default SharePoint Lookup, the SPJS-Lookup or vLookup?
From the Child item, if I select the Parent, then go back to that Parent item, will it show up as a vLookup Child item?
January 15, 2019 at 20:23 #23526
I mean the standard lookup column. Look at the attached images for a setup example.
January 23, 2019 at 01:02 #23604
I’m staring at your replies above and have no clue what to do in DFFS config. 🙁
I’ve got the standard Lookup added to the Child list.
Person opens up New item and can select from drop-down of Parent items but that’s as far as I have got.
With your images above, is that connection to be configured in the Parent as a new vLookup connection or in the Child vLookup config?
Are there some instructions I can follow to configure the Child List connection to the Parent?
Thanks for your time.
January 23, 2019 at 19:29 #23614
This article describes the standard method of setting up a parent-child connection with vLookup: https://spjsblog.com/vlookup-for-sharepoint/vlookup-setup-example-for-sp-2010-and-2013/
If you combine the query from the article with the one in my comment above (use “or” between them) you should have a connection that pulls back both items already created with vLookup from the parent, and the ones created directly in the child with the lookup column connection to the parent.
You can also replace the default connection that uses _vLookupID / _vLookupParentID with only the one on the lookup column as long as you pass the parent ID to the lookup column in the child when you create an item from the parent. You would need to edit all existing child items to have the lookup to the parent before you remove the _vLookupID / _vLookupParentID connection.
Please note that you cannot use the default lookup column connection if your parent list ever exceeds 5000 items.
January 24, 2019 at 23:22 #23637
Thank you Alexander,
That worked perfectly, much appreciate your time and effort on this.
- You must be logged in to reply to this topic.