Jump to content

Trouble: calculating multiple related records in a portal


This topic is 6497 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 by Guest
Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

This topic is 6497 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.