Add several services to an appointment

Hello!

I´m creating an appointment app for beuty services. The idea is to register all the appointments and on each appointment, register all services the client will take.

I have the follwoing tables: Appointments, Services and AppointmentServices

Appointments: IdAppointment, day, time, client, etc…
Services: IdService, name, price, duration, etc…
AppointmentServices: Id, IdAppointment and IdService (table to relate each appointment with 1 or more services).

When creating a new appointment (form) I want to have a dropdown* to select several services to it and after closing, display the list of all services I´ve selected.

It could be a dropdown or a button to go to another page where I can add the services and save.

Thanks!!

0 5 416
5 REPLIES 5
Top Labels in this Space