I am looking to setup a simple form for people to report locations of invasive plants of which there are about 5 types.
It would seem logical to have a dropdown on the form where you select the plant type from options 1-5 and this will put all the data in one table.
But if then I want to display all locations of plant 1 on a layer - can this be done? Maybe the layer is populate by a select * where type statement?
Is this possible and the best way to set the data up (vs a form for each plant type).
Cheers
Al