Repaeting Field Calculation

[Ricardo]

Hi All,

i have a got a field with 8 repititions. each rep has and entry of Pounds(

[Ricardo]

i've worked it out -used the extend function!!!!

[LiveOak]

Exactly correct. When you multiply a repeating field (vector) by a non-repeating field (scaler) you must use the extend function:

VectorField2 = VectorField1 * Extend(scaler)

(just expanding a little for our other readers...)

-bd

[danjacoby]

Why Oak, I'm surprised you didn't take the opportunity to say "Don't ever use repeating fields." I certainly shall:

Don't ever use repeating fields.

OK, that's not exactly true, but if there's a way (and there almost always is) to use a related file, it's nearly always much better.

[LiveOak]

I have a confession to make. My invoice database (an old FM 2.1 relic) uses repeating fields. My excuse is that working on my own files is a non-billable activity, so the shoemaker's kids go barefoot...

-bd

[danjacoby]

Truth be told, my invoice DB used to have repeating fields too, but I've fixed that.

The only time I use repeating fields now is as a reference for conditional value lists. If I only have, say, Category and Subcategory, then the related file will have the two fields, with one record per Category, and a repeating Subcategory field. I find it easier to edit the lists that way.