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.
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.