I have 2 tables:
Here is a description of some fields:
Grand total, number.
On the vehicle registration page, I have a Dropdown with the options, sale, purchase and lease.
Another Dropdown with models, Honda Civic, Honda CR-V, Honda Fit, Honda City.
I need to save the sum of the results found in the other table in a table.
What I need to do is this.
Count the records in the vehicles table and store them in the topics table to build a report as follows:
Model For Sale For Purchase For Lease
Honda Civic 20 Vehicles 15 Vehicles 10 Vehicles
Honda Fit 10 Vehicles 5 Vehicles 20 Vehicles
General total of registered vehicles: 80 vehicles
Dirceu M. Azevedo