Only need one occurrence.

["... you mean these fans?"]

Hi,

 

I have to look at my Invoice Table, from my Project Table.

 

How can I write a calculation in my Invoice Table that will only calculate my Project Sequence once, see pic.

 

I have a relationship on my Invoice Table back to my Project Table to show the Project Sequence by Invoice ID to Project Invoice ID.  I need this, each invoice that is assigned to a project I can see the Project Sequence along with the Invoice ID see first .pic. ( though I don't look at this relationship this way )

 

Now, I need another calculation on my Invoice Table see second .pic that will only enter the Project Sequence ONCE no matter how many invoice are assigned to that particular Project Sequence.  I'm thinking dynamic as well, as the invoice move from open to closed, the project sequence will need to move to the next invoice open ( but only one occurrence )  

 

Any suggestions.

 

 

Thank you.

Tom :-)

 

[Pavlk]

If you want your report to look this way, you won't need to use portal. Better make a layout report and and place sub-summary part when sort by Project Sequence.

["... you mean these fans?"]

Sub Summary, oh yeah.  Oops!  Forgot about them sub summaries. Hehehehehe  :-)