Trouble: calculating multiple related records in a portal

[Gilbert]

In my file I have two tables (Projects) and (COTItems). These two tables are related by the following relationship.

[color:red](COTItems) / [color:red](Projects)

ItemID ----------------ServiceCodesID_Glob AND

ProjectID -------------ProjectID

I will like to use a Tooltip to display the higher value in field: UnitLabor for all related records base in my relationship.

Example:

I have a value of: 10 for record #1 and a value of 20 for record #2. Wend I create record #3 and place the mouse on top of the field: [color:red]UnitLabor the Tooltip should display 20 for A01 and 30 for B02 base on the higher value of all existent related records.

Please take a look at my sample file

I appreciate any help

Thanks.

Summarydb.zip

Edited June 5, 2006 by Guest

[mz123]

Hey there,

It must be because its a summary field. If you look at the attached file, it works if I create a self-join (no real relationship, just shows all records) and if i use the max() function.

So it seems like a calculation will work, but not a summary field.

I hope that helps!

Summarydb.fp7.zip

[Gilbert]

Hi, MMS6F

If I have a value of 10 for item A01 in record #1 and value of 20 for item A01 in record #2 the tooltip should display 20 for item A01 in record #3 and 30 for item B02 in record#3.

:help:

Edited June 5, 2006 by Guest

[comment]

Do you mean something like this?

Summarydb.fp7.zip

[Gilbert]

I modify the technique you show me in the first sample file. It is perfect for what I need, in fact thanks to this technique I add new functionalities to my solution

:thankyou:

Summarydb.zip

Edited June 8, 2006 by Guest

[Gilbert]

Part 2.

I need to find a way for my Tooltip calculation to display the project ID in addition to the max value

Please take a look to the sample file

Thanks.

Summarydb_Part_2.zip