1- I have a layout in my INTERFACE file showing Customer ID , adress,
etc.from a related table in the DATA file
On this layout I also have a portal showing Services, cost of service, date
, etc.( from an other related table in the DATA file.)

I have a Summary FIELD showing the total of the cost. When I add a service ,
the total (summary field) does not
auto update. I have to click in the summary field to get it to update. Is
this the way it should work ?

What would I have to do to get the total updated each time I add a service
bought ???

2- If I understand correctly, I think that the Summary field totals the
items cost in the portal for the current record.
From what I read ,it totals the found records.
Since the data comes from a related record in another file, what happens
when I have 100,000 records in the data file.
Will the summary field (witch is really in the data file), total ALL the
records in the data file ?? What about the speed of operation ? Will that be
a problem ??

If so, what would be the best way to proceed ??

Thanks
Claude

Usually you use a calc field for totals in browse mode; the calculation
is eg.
Sum(TableReference::FieldName)

The same Table Ref is used for both the portal and the calc. If you
try to display 100,000 records in the portal, the calc will try to
summarize 100,000 records.
Since portals usually only show a couple of records, the calc should be
quick, it doesn't care how many records are in the file because it only
looks at a small subset.

I see that in the INTERFACE file , only a few records show in the portal. So
the Summary should be fast.

But, the records I see in the portal are really in the DATA file. If that
DATA file contains 100000 Records
Won't that take time to calculate ?? Or does it only summarize the records
I can see at one time.

If I look in the DATA file at ONE record at when " All records are found" I
get the TOTAL of ALL the records.
That could take time.???

Also , why do I have to click on the summary filed to get the update total
of the portal when I add a new item in the portal.
I thought it was supposed ti update automaticaly ??


"FP" <a (AT) pottnerconsulting (DOT) ca> a écrit dans le message de news:
1129182170.617169.194810 (AT) z14g20...oglegroups.com...

Use a calc field instead.