Good afternoon,
I have a members database, and have the Invoice template installed. What I want to do when I create a new invoice I want to put the company name and use autofill to collect the number of children and number of adults and place them into the invoice template.
I currently have this which works for auto completing the children's figure, but as soon as I want to amend to bring in the adults it does a multiplication of children and adults and places that sum in each box.
SELECT
brigade_id.Company_name,
COUNT(child.Counting) AS COUNT(Counting),
brigade_id.Company_CO,
brigade_id.CO_email
FROM brigade_id
INNER JOIN child ON brigade_id.Company_name = child.company
GROUP BY brigade_id.Company_name, brigade_id.Company_CO, brigade_id.CO_email
Wonder if anyone is able to shed any light on this please as I've been working on this for 20 hours and still can't work it out, even with google searches.
Thanks in advance.
Jason