Is there any way to filter releated fields values with dropdowns choise?
Hello! I have two views with records like
View 1
View 2
Field A
|
Field B
|
| 1 |
A1 |
| 1 |
B1
|
| 1 |
C1
|
| 2 |
A2 |
| 2 |
B2
|
| 2 |
C2 |
Both views have fields 'Field A' with values corresponding to each other
I need to create a form 3 where selection 'Field A' value = '1' in dropdown for the 'Field B' will show only records 'A1,B1,C1' (releated to 'Field A' value = '1')
and on select 'Field A' value = '2' in dropdown for the 'Field B' will show only records 'A2,B2,C2' (releated to 'Field A' value = '2')
is there any way to have this done? will appreciate help a lot!