I want to implement a two way for the below scenarioa
I have 6 fields lets Say
Common Name
-Scientific Name
Genus
IUCN status
Family Name
So , The 2 way filter should work for common name and scientific name as data collection user may know either scientific name or common name ,So,
-If he filter commoname then other 4 fields should be filled automatically (Scientific name, Genus, Family , IUCN)
Similarly when scientific name is chosen then other rest 4 fields should be field like (Common name, Genus, family and IUCN).
Common name and scientific name should be as two way filter
Why not use one (combined) select, showing common name - scientific name together in each choice label? And then fill automatically the following fields. The filling could be done based on additional column in the choice list.