In Excel you can make a spreadsheet. In every header you can select then on every interpretation of the cels. But a disadvantage of Excel is that you cannot work with several employees simultaneously (in a network). For that access has been extremely arranged.
I am designing therefore a database for building with the same functions. But I get bogged down at developping the form.
What the database exists:
= main table with subject, remark, employee, date, status, machine.
= 3 extra tables: machine, employee and status (finished j/n).
What is therefore want to design : Form with subformulier. The subform are/look then similar with excel spreadsheet.


In that form above the subform: 3 choice fields which should filter all records matching to the filtercritiria (machine, employee, status).
When I select nothing/filter in the choice fields, the subform must show all records / data. In those subformview I want to be able to make changes to the data. Or add record.
Do I have to build relationships ? Can I use queries or design everything by means of codes? Who can give a total recommendation.
Thanks in advance, Aragon