Good Afternoon All
I have a question with regards to a Database that I am building as a project. I am a therapist and I built a Client database that with apointment table so it can basically record the history of my clients appointments. Here's the fundametals of what I want my appointment table to do:
I have a field called TimeNextAppointment - this is formatted to short time and I have done a lookup to a Time_tbl that has from 00:00hrs to 23:30hrs (my appointments go in half hour increaments). Also in Appointment_tbl I have a field called DurationSession, this looksup data in Duration_tbl, and is gives the options from 30 to 240 minutes slots. So what I want to achieve is when I select the appointment time, say 14:00hrs and the duration of the session is say 30 mintues in the FinishTime field I would like it to auto populate with 14:30hr.
Can this be done?? and how can I achieve this??.
I have searched everywhere on web and in books but have not found a solution that helps me.
Thank you in advance for assistance given.