This is a bit complicated so please stick with me!
I have a form that I enter Supplier information into, in this case suppliers could be a hotel, or an activity site for example. It's just a table with supplier information.
Because certain suppliers can provide services to multiple towns I have 36 check boxes that can be ticked to show which towns the supplier can be used for. SO for example...
Supplier A could have 3 locations selected using tick boxes.
Supplier B could just have 1 location selected.
etc etc
However, when we get a booking we enter the customer information onto a form. I select their location from a drop down and get this drop down to put a tick in "same named" hidden tick box on our hotel details page. I then go to the hotel details page to select their hotel.
As it stands I have a drop down that pulls in ALL the hotels from our supplier form but I would like it to pull in JUST the hotels that are relevant. I.e. the tick boxes on the 2 forms match up.
So...
Customer is visiting London.
The Hotel form has a tick in the London Box
I want the dropdown on this form to show all the Hotels from the Suppliers table that have a tick in the London Box
I'm not sure if that makes sense or not
I have a form that I enter Supplier information into, in this case suppliers could be a hotel, or an activity site for example. It's just a table with supplier information.
Because certain suppliers can provide services to multiple towns I have 36 check boxes that can be ticked to show which towns the supplier can be used for. SO for example...
Supplier A could have 3 locations selected using tick boxes.
Supplier B could just have 1 location selected.
etc etc
However, when we get a booking we enter the customer information onto a form. I select their location from a drop down and get this drop down to put a tick in "same named" hidden tick box on our hotel details page. I then go to the hotel details page to select their hotel.
As it stands I have a drop down that pulls in ALL the hotels from our supplier form but I would like it to pull in JUST the hotels that are relevant. I.e. the tick boxes on the 2 forms match up.
So...
Customer is visiting London.
The Hotel form has a tick in the London Box
I want the dropdown on this form to show all the Hotels from the Suppliers table that have a tick in the London Box
I'm not sure if that makes sense or not