I am stuck with the extend function.

i have tried but no luck in getting anything to work.

Can someone take a look at my file & point me in right direction?

thanks,

extend.fp7.zip

It's not clear exactly what result you are trying to get in the example. Can you clarify?

Ouch, my reputation. Someone didn't like my reply.

Edited September 9, 201114 yr by jdu98a

Can someone take a look at my file & point me in right direction?

Is it this ?

extend.zip

no. if someone clicks on the "ACTIVE REPETITION #" i would like to make sure and extend lets say a label underneath that with a regular field that i can put information in.

hope that makes sense.

Not really. Which is in your mind the "ACTIVE REPETITION #" ?

I'm not sure what you're trying to achieve but I think all you need to do is change your script to the single step

Set Field [ NAME::labels; Get ( ActiveRepetitionNumber ) ]

I have concluded that using extend( ) function makes NO SENSE TO ME instead of just another repeating field , put some buttons behind the containers if you want graphics and call it a day.

WHY EVER should you use extend?

i dont see the need i guess until i have the need.. LOL

WHY EVER should you use extend?

If you're using repeating fields, to EXTEND the value of a single-repetition field across a field with multiple repetitions.

I have finally figured out extend .. OMG!!!

All it really does is :

1. if u r using it in a calculation

2. eg. (cost[5] * rate) { Where cost is a repeating field }

if you put rate as rate = 4. then your calculation will return cost[1] = 20 cost[2] = "" , cost[3] = ""; etc

if you use extend(rate) then ALL the repeating fields will use the rate number.

-i

Great.

But why are you using repeating fields? In 99% of cases a related table is better.

Learning all that i can while i can with Filemaker. { i am becoming an addict} Cant make art without knowing how to paint? At least that is what i say!!