I'm trying to create a view by using a Pivot and joining about 3 tables together.
It's for a reservation module where people book appointments. Most data is stored in the main table called:
However custom fields are stored in another table called:
In the first example attached - which works - custom fields are shown in the view ok.
The problem I have now is that people can book appointments for different local offices (Sheffield, Barnsley, Doncaster etc) - these are stored inside another table called:
I'm struggling to reference the fields in this table in my view.
the attached file shows full screenshots of my tables and desired outcome. Any thoughts welcome. thanks for looking.