Hi
I have a project with dependant dropdowns called 'CARS' and 'CAR MODELS', so when the user selects BMW from cars only relevant models are shown such as 3-series, 5-series etc.
In another field, I have the users location, this field is called 'CITY' and contains London, paris, rome, madrid etc according to the users location that is held in the GroupID session vairable and auto-filled in when the user adds a record.
Another field is called 'SOLD' and is empty if not sold and is full if it is sold.
I would like to create a report that shows what cars are available in what city that aren't sold. So it would look like:
BMW 3 Series:
London - 10
Paris - 5
Rome - 2
BMW 5 Series:
London - 10
Paris - 5
Rome - 2
etc etc
For each manufacturer and model..... better still it would be good if the report user can select what 'CARS' and 'CAR MODELS' they want the report for using the dependant drop downs at the top of the page.
How do I achieve this?