Appointment Schedule (1 Viewer)

JPR

Registered User.
Local time
Today, 13:51
Joined
Jan 23, 2009
Messages
192
Hello. I am planning to design a form that can be used to set appointments for the customers listed in my db.
Data related to customers is stored in tblCustomers and appointments time/date is stored in another table, named AppTime. Appointments should be available from 09:00 to 05:00 with slots every 15 minutes. I was wondering if anyone can guide me through the best way to set up this.
I understand that I should create a query based on the tblCustomers but honesly to not know how to fit in the table AppTime.
Thank you for any help.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 04:51
Joined
May 7, 2009
Messages
19,169
google and download Peter Hibb's appointment calendar database.
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 16:51
Joined
May 21, 2018
Messages
8,463
Peter Hibb's calendar is in the thread above.
 

Users who are viewing this thread

Top Bottom