I’m seeing some problems when updating some columns to which there are dereferences …
I hope I’m gonna explain this right:
So there is a table called - Types of Projects,
a table called - Projects
Types of Projects have many Projects.
Then there is a table called Tasks and it’s rows are Tasks, each belonging to a Project
In the Tasks table there is a column - Projects - that is a reference column to the Table Projects. And there is a column called Types of Projects, that is a dereference to the Type of Project that Project is.
In a deck view of Tasks, I have a show if condition, to show only the Tasks belonging to a certain Type of Project. So the point is when I edit the Project to a different Type of Project, all of its Tasks will not show up in this view anymore.
But the problem is that when I edit a Project and change it’s Type of Project, in the Tasks Table I can see that there is no change on the Type of Projects column, so they still show up.
Shouldn’t they update automatically through the dereference?
What I notice is that, if I do the change, and then open the edit form for the Task and just close it again, without changing anything but hitting the Save button, the Type of Project updates … but that would be really … annoying to have to do. There must be a better way or something I’m missing.
Any ideas what I forgot to click?