Complex form, multiple type select each selected value to be displayed in single form to collect data from all select distinct tables
In MariDb I have a table request with few fields that collect some basic data
eg.
request_id
name
email
phone
…
I have a table request_types linked with table request with values
accommodation
bus_ticket
flight
airport_transfer
car_rental
cruise
User can select multiple request_types in table request.
Each request_types has a linked/correlated table eg.
accommodation_request
bus_ticket_request
flight_request
airport_transfers_request
car_rentals_request
cruise_requests
How can I achive that if user select one or more or all request_types to collect and display fields from related tables in same form for request.
Here’s the comprehensive list of fields that would be displayed and collected from values if all services are selected:
Main Request Fields (from solicitari)
Client information
Employee
Request date (data)
Deadline (data_deadline)
Status
Description
Adults count (adults)
Children count (children)
Children ages (children_ages)
Flexible days (flexible_days)
Remarks
Accommodation Service Fields
Destination city (destination_city_id)
Check-in date (check_in_date)
Check-out date (check_out_date)
Meal plan (meal_plan_id)
Total rooms (total_rooms)
Budget (budget)
Flexible days (flexible_days)
Bus Ticket Service Fields
Trip type (trip_type)
Departure city (departure_city_id)
Arrival city (arrival_city_id)
Departure date (departure_date)
Return date (return_date)
Flight Service Fields
Trip type (trip_type)
Departure airport (departure_airport_id)
Arrival airport (arrival_airport_id)
Direct flights only (direct_flights)
Departure date (departure_date)
Return date (return_date)
Airport Transfer Service Fields
Transfer type (transfer_type)
Direction (direction)
Airport (airport_id)
City (city_id)
Departure date/time (departure_date)
Return date/time (return_date)
Passenger count (passenger_count)
Flight number (flight_number)
Notes (notes)
Car Rental Service Fields
Pickup location (pickup_location)
Pickup date (pickup_date)
Pickup time (pickup_time)
Drop-off date (drop_off_date)
Drop-off time (drop_off_time)
Different drop-off location (different_drop_off)
Drop-off location (drop_off_location)
Cruise Service Fields
Destination (destination_id)
Departure port (departure_port_id)
Duration (duration)
Departure date (departure_date)
Notes (notes)
Any help would be appreciated.