Tricia S.

Forum Replies Created

Viewing 31 post (of 31 total)
  • Author
    Posts
  • in reply to: vLookup within a vLookup using Listview #27077
    Tricia S.
    Participant

    I have a solution that might work.

    What I do is rather than use the the prefill _vlookupParentID, I use a combination of Rules and Cascading drop downs.

    This looks to the deepest level I have:
    Here is the lookup list Field:
    ProjectNumber/Title,PoPMap2,Title,SLINNumber,OData__vLookupProjectID,OData__vLookupParentID,OData__vLookupID,Status,ProjectNumber/ProcasProjectNumber
    and Here are the current list fields:
    Project,RelatedPoP,RelatedCLIN,RelatedSLIN,_vLookupProjectID,_vLookupPoPID,_vLookupParentID,CLINStatus,ProjectNumber

    Each level is going to change a bit:
    Deepest level:
    _vLookupProjectID= Project
    _vLookupPoPID= POP
    _vLookupParentID=Clin
    _vLookupID= Self

    Vs if I go to the CLIN setting Level
    _vLookupProjectID= Project
    _vLookupParentID= POP
    _vLookupID= Self

    Autofill subsequent dropdowns when they contain only one valid option needs to be selected.
    On my project list I can see all related Grandchildren and great grandchildren as different vLookup lists.

Viewing 31 post (of 31 total)