I'm building a form to collect observation data of species. I have a layer called "observation" (point) with a field called "observer", it is the name of who sees the species. Secondly, I have a table with all the employees of the company.
In my form, I use a relation value for the field "observer" with my table, so that I have a drop-down menu with all the employees. It works perfectly.
The problem is in my layer "observation", I have many other observers, and they disappeared when I used the relation value, cause they are not in the list.
How can I have a drop-down menu with my employees, for new inputs through the form, but still let me have other "old" records with different employees?