Appointment Schedule

[JPR]

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]

google and download Peter Hibb's appointment calendar database.

 

[MajP]

Date Pickers, Calendar Controls, and Calendar resources

There has been some recent interest in a replacement for the MS calendar control that existed prior to 2010. I have been collecting date pickers, calendar controls, and calendars for a long time and thought it would be a good idea to have one thread with lots of good examples. Some of these...

www.access-programmers.co.uk

Peter Hibb's calendar is in the thread above.