How to organize a database for freelance collaboration?

Question

Database

There is the following banal task: several people working remotely fill in the database. We used to do it through Google Sheets, now we realized that we need something more flexible and adequate.
I would like a person to open the form, select the desired position from the drop-down list and:
1) see the old entries for this position,
2) be able to add new ones there.
I feel that this is a very simple query, but I could not google anything like that about Access ...

Answer 1

What is the position (in your subject area)?
How many positions?
How many old records can be maximum (pessimistic estimate)?
Can you show an example?
The fact is that just Google Sheets and filters are perfect for all your formal criteria. And the choice and then add something. It is not caught in what inflexibility.