Reverse lookup from child to parent
In my app I have a list of Parents, each of which is linked to one or more Children through a multi-select Lookup field in the Parent form.
I can make views based on Parent, which can show values from the Child form as well. This is excellent.
However I also need some views based on Child, which show each child in a separate row, with their Parent's name and other information.
To work around this I put a single-select Lookup field in Child that links back to the Parent, but then when creating a new Parent and Child the poor user has to create the Parent, create the Child with a single-value link to the Parent, then go back to the Parent and update the multi-select lookup field to link back to the child.
Could I script this part by automatically updating the lookup field in Parent when a new Child is saved?
It would be nice if when I create a view based on Child, Creator could detect the existing lookup field from Parent to Child and allow me to add values from Parent to the view.
I have shared an application called "Problem demos" to support@zohocreator.com which demonstrates this (forms and views starting with "Two-way"). Thanks in advance for looking at this.