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.