Valuelist + Calculation field refresh issue

[AvrioTech]

Hello im having a valuelist + calculation field issue. When I change information in my valuelist field (in a portal) my calculation fields not updating unless I click on a blank spot on the record.

As you can see in figure 1 (image below), I have a field that shows how many related contacts are per location (in blue and underlined).

The formula im using for that is:

TextColor (

TextStyleAdd ( "Related Contacts (" &

Count ( CustomerEmployeesBYVendorIDLocationID::RecordID ) &

")"; Underline)

; RGB ( 0 ; 0 ; 255 ) )

and I have a portal where I can view All contacts (related of not) and I can chose what location by a pulldown menu that contact belongs to.

My Issue is that my related contact calculation doesnt update when I change the location of the contact and go to the next field, unless I click somewhere on the record. Is there a way to make it update as soon as you leave the field?

The image blow is showing this

Figure 1 = before I change any information, notice only one record in the portal is related to the main address above so the related contacts shows "Related Contacts (1)" which is correct.

Figure 2=Show me changing the 1st record in the portal so that 2 records will be related to the main address.

Figure 3=Shows my issue.. Its showing that the Related contacts still shows 1 even though 2 records are related.

Figure 4= Shows it working , but only after I click on a blank area of the record.

CLICK HERE TO SEE BIGGER

Edited October 12, 2006 by Guest

[normanicus]

I'm glad you asked this question because I have the same thing. I experimented and found that it happens if the relationship is between separate files but, if one creates the same structure with two tables in the same file, it works OK. Seems to be an instance where FM does not do what is said on the box i.e. functionally, tables work like files.

I believe there is a way to use calculated validation to solve this and await another reply. I am looking at either integrating my files into tables - a very big job, or using the free EventScript plug-in,

Norman

[AvrioTech]

Believe it or not its in 1 file but different tables. The only things that seems to refresh instantly in this case are Aggregate Functions in a calculation field.

Ex Sum, Count, List ect..

I had a portal for all contacts for a business so not every contact was related to the same location in my portal. So Count wouldnt work for me.

So What I did was created a calculation field that used the list command then did a pattern count.

PatternCount ( List ( CustomersEmployeesByCompanyID::LocationID ) ; CustomerLocationsMainAddress::RecordID)

Hope that helps. It works great for me. If you have trouble try uploading your file somewhere and ill take a look at it.