portal child over text field how to

[imoree]

hey everyone. i have an issue.

I am wanting to do something like my user enters cake flavor & then qty and it appears on a portal, however. I would also like there to be a running total on the page somewhere that can calculate the total as they are entered.

i am using a portal ---child over my text field, then qty the same. Only thing is how to calculate a running total.

thanks,

-i

p.s. _ Attached file may help those who see what i mean

fridays Copy.fp7.zip

[Fitch]

Sounds like you are talking about a Sum( related::qty )

[LaRetta]

Since your Entry table has a summary which is Total of Quantity (running) then you can just place that summary field (I would name it something other than sum) in your portal as well. :^)

And for looks, you can take that same summary field, duplicate it and place it below the portal to signify the overall total also.

[imoree]

Hey Thanks so much, now if you take a look at my RG, i had to do a cartesian Flush trick to update portal if changes occur immediately,

Does this look ok? or can this be made even simpler?

[LaRetta]

Your layout is based upon Sales and the portal is based upon Entry Main. If I understand your request correctly, you do not need that second Entry Main 2 table occurrence. From layout mode, select Insert > Field > Entry Main > Sum field and place it into that existing portal belonging to Entry Main. That summary will provide running totals of quantity added in the portal.

"cartesian Flush trick"

Oh too funny!! Instead, I suggest that you attach a script trigger to the quantity field, OnObjectExit. Script will be simple Commit Records/Requests[no dialog].

[imoree]

LaRetta - Thank you . Glad i made you laugh... Works beautiful.. NOthing like windows is all i can say. Everything you need to account for in this program.

still new to me.

-i

[LaRetta]

I'm going to go fix myself a cartesian flush. I just love the sound of that together and it still tickles me. You are doing really well for being so new. Welcome. :)

[imoree]

Hello , Can someone explain to me how / why this works?

placing the field of foreign table (with create child record enabled)

over portal the size of the textfield

A larger portal based on foreign table ( without create child record enabled)

with same fields inside portal to "show data information".

this is confusing to me why it works.

hope this makes sense to someone.

-i