aggregating portals which is aggravating me
I have a portal in 'invoices' that links to 'lines' the two tables are in a relationship via clientID. the portal is filtered by 'line date' (from the table "lines") must be between "invoice start date" and "invoice end date" (from the invoice table) this bit works.
I have an aggregate function to sum "costs" from the table "lines" but it sums all line linked to that client and not just the ones in the portal.
I do not link the two by invoice ID as i don't want to add invoice ID's to the lines until they are in an invoice
can anyone help?