2

We have 2 relationship lists such as Category and Sub Category List We successfully set cascade behaviour in the new item page.

$().SPServices.SPCascadeDropdowns({
       relationshipList: "relatLv0ToLv1",
       relationshipListParentColumn: "Parent",
       relationshipListChildColumn: "Child",
       parentColumn: "CategoryLvl0",
       childColumn: "CategoryLvl1",
   });

After save, the information displays correctly. However, when we tried to edit item, the child category always show none instead of its value

enter image description here

Do you guys have any suggestion?

Regards

Improve this question
5
  • I use Sparqube lookup columns, by default they do not allow edit in the DATASHEET view. This can be changed in the column settings though. From your question it is not clear if you are using a Datasheet view or simply trying to edit the item (Edit Form).
    – Tally
    Commented Feb 5, 2019 at 11:54
  • 1
    have you added the same code to cascade dropdowns on both new and edit form?
    – Ganesh Sanap - MVP
    Commented Feb 5, 2019 at 12:42
  • Yes, I added the same snippet in the new and edit form. Actually, in the edit form, the value in the dropdown is filtered but it just display (none).
    – Andy
    Commented Feb 5, 2019 at 13:40
  • Is that the only function/piece of code you have in your forms?
    – Christoffer
    Commented Feb 5, 2019 at 14:38
  • Actually, there is two line for importing the jquery and spservice and then this piece of code. This is the same script that we use for both newForm and editForm. The newForm work correctly. But the editForm could not select the store value and display none. I suspect that the event was fire so then the cascade is loading to none.
    – Andy
    Commented Feb 5, 2019 at 18:25

1 Answer 1

Reset to default
0

I think I found the root cause. The problem occurs if we use the lookup column fields as parent. If we change the parent field from lookup to simple text, it's working fine.

Best Regards,

Andy

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.