Summarizing Only Most Recent (Or First) Related Records
i have a solution that contains a parent table (e.g. "invoices") and a related table (e.g. "line items") which are related by "invoice number". an invoice may contain any number of line items (from zero, if it is not finished, to perhaps as many as 15 items).
is there an easy way to calculate (either with a calculation field or a summary field) the total of only the first item from all the invoices (e.g. the 1st line item from invoice #1 + the 1st line item from invoice #2 + ... + 1st line item from invoice #n )?
i know i can create a calcualtion field on the invoice and set it to equal the line item total for the first line item based on the way the relationship is sorted and then summarize the invoice calculation field... but is there a way to do it without creating this itermediate field?
please help... thanks!