I just finished my first class on Access at the local community college. I am trying to set up a database for my office that I could use as a chart noting application for my chiropractic office. I am struggling with the set up. How do I organize the database so that I can have multiple dates of service for a single patient? I have created a table of patients that has their demographic info, and a key that will be the patients ID number for the database. Do I keep each date of service as a separate field?
Need help getting started. Any pointers would help.
Peter