Summarizing repeating fields?

October 29, 200322 yr

I have an invoice layout that contains repeating fields for quantity, style number and color. What I would like to do is summarize the quantities for each product (by style number) so we can obtain the quantities for the top purchased products in the past six months, and therefore know which products (and in which color) we should bulk purchase.

The trick is (at least to me), since we use repeating fields, the lines vary, and the products are often listed on different lines from record to record. I am unsure of how to create fields on a new layout to summarize by product.

I'm sure there is a simple solution to this problem, I just do not know FM very well.

Thanks in advance!

-Courtney

October 30, 200322 yr

cpatubo said:
I'm sure there is a simple solution to this problem, I just do not know FM very well.

Not really Courtney. Since you use repeating fields, this would be a *big* pain in the....

I've lost much of my "repeating fields" knowledge, but IMO, this would be done by investigating each repetition, in each invoice, using a Loop script.

Once you've buil it, go take a cup of coffee and wait for processing...and while you drink it, think of implementing some relationship principles, which would make your life *really* easy.

October 30, 200322 yr

Ugo is right, you should really migrate to Invoice--LineItems structure instead on Invoice+RepatedFields

To achieve this simply export data (invoiceID + all repeated fields regarding products)from your current Invoice db to new database with option export each repetition in new record enabled.

BTW, Ugo, I'm struggling to find the "any" key on my keyboard, maybe I should by the french version...

Dj

October 30, 200322 yr

That would be the "quelque" key.

November 3, 200322 yr

Author

Ugo DI LUCA said:
Once you've buil it, go take a cup of coffee and wait for processing...and while you drink it, think of implementing some relationship principles, which would make your life *really* easy.

LOL... the coffee part sounds splendid.

I'd rant about my client here, but that is a whole new topic/headache. I created their DB to spec (it was efficient when it was first created), then they decide to change their minds every week...