Hello everyone,
I'm currently building a database for my internship site for a ticket/help desk system. Here's my question, upon research online I haven't been able to find any answers.
- I want to have multiple users be able to log into this system
- I want each user to have their own view when they log in
- ex: when they log in they can view only the tickets they opened since they would be saved based off their username and password
- When they go to enter a ticket the DB automatically realizes who they are are opens the ticket in their name
These are just a few things I have in mind at the moment and just want to know if it's possible to build it this way.
I could do it by having different forms for each user and when they login with the correct username and password it opens the form that's linked to their name but this will take up a lot of space. The more users --> more forms, and I don't want to go this route.
Thank you