Let's say I have 3 layers:
- point layer (columns: id, group),
- table layer named materials (columns: point_id, mat_id),
- table layer named mat_list (columns group, mat_id).
There is relation between point layer and materials table using id and point_id and value relation materials - mat_list.
In mat_list I grouped materials for example:
What I want to do is after I pick group in point layer it will limit choices to pick in materials layer.
More information maybe usefull
table/layer with material list
layer with points.
Relation between point and material.
In this screen I want to limit materials to group_2 so drop down list will show material_4, material_5, material_6. But group is picked in point layer not material. Is there any easy way to accomplish it.