Hey All,
Been a while since I worked in access so I'm a bit rusty. Using access 2016 32-bit
I'm working on a database not of my own design. My friend wants to be able to keep a running tab of what service a client took and the date they took it. They want to be able to view and update the info from within the clients profile page. What is the best way to do this?
Think of it like a quickbook register. Where you can go to a field in that register and click the drop down to select from a list of services and select 1 service you click accept or whatever and it puts the current date in the date field. then it goes down to the next line and so on. This must be part of the clients profile.
Ultimately they want to run reports on how many people used a specific service within a specific time frame.
Maybe a better example would be like a doctors office. The patients profile comes up and the nurse can see when you were there in the past and what you had done each time. They also need to add new records.
How do I do that?
Thanks