Form with pivot + filtered datasheet

[kwag]

Hey,



before I ask my question: I have very limited access knowledge so I'm aware that my question is rather simple, so if you think "he could google it" - I tried. Unfortunatey solutions which I found are not best... but If u can point me to good source with access tutorials - will be grateful

So. I have one very simple table.

Employee Name - only 4 possible values there
Status - only 4 possible values there
Customer info

And I want to create form for user in which I will have:
Filtered datasheet - so I can see (and edit) ONLY records which belongs to employee x, but I want column "Employee Name" to be hidden and unable to be seen by user - I know I can make simple query with filter and put in form, but is there better solution? Ofc I can put subform , filter it and hide column but user could just unhide it.

Pivot table or chart - so user will have quick overview how many and which statuses he has - Thats giving me a problem...

Will be grateful for hints.

[June7]

Who is 'user' - the 4 employees?

How does Access 'know' which employee is the user?

Column is not available to be hidden or unhidden if there is no control bound to the field on the form.

[kwag]

Yes. Employees are users.

I was thinking about splitting database and providing each user with different front-end.

[June7]

A multi-user database should be split but distributing different versions of the frontend sounds like a maintenance headache.

Another approach is a login procedure.

Another is to grab the username from the network login.

[kwag]

I see. Thank you for hints.

Maybe you have some sites with info where I could find out how start constructing frontend with login?

And any advice for creating pivot inside form filtered by user/employee name?

[June7]

Login procedure is common topic. Search forum. Here is one https://www.accessforums.net/access/...gin-23585.html

Explore pivot table/chart and CROSSTAB query. Cannot do data entry/edit with those structures.