Can not Index

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

Hi,

 

I have an invoice table with the following fields ...

 

Days OverDue and Invoices OverDue

 

Days OverDue: ( Basically a positive, or a zero, or a negative, or empty if text )

 

If ( IsEmpty ( Filter ( Terms ; "0123456789" ) ) ; Date Delivered - Search Date ; /* Field Terms could have Text - Immediate / Upon Receipt */

 

If ( Filter ( Terms ; "0123456789" )  ≥  0 and Search Date  ≤  ( Date Delivered + Filter ( Terms ; "0123456789" ) ) ; ( Date Delivered + Filter ( Terms ; "0123456789" ) ) - Search Date ;

 

( Date Delivered + Filter ( Terms ; "0123456789" )  ) - Search Date ) )

 

 

Invoices OverDue: ( Basically if above; Days OverDue is zero or below to populate "1" )

 

If ( Days OverDue ≤ 0 ; 1 ; "" )

 

The problem is that in the first calculation, I had originally used "Get ( CurrentDate )" but had to replace it with my global field "Search Date" because I needed my "Days OverDue" field to calculate each time I started the database and since the Get ( CurrentDate ) only worked if the "Date Delivered" change which it never did once the date was entered I was forced to replaced "Get ( CurrentDate )" to "Search Date" within the first fields calculation which now is a global field and I now populated it with a Get ( CurrentDate ) script step on start up.

 

WORKS GREAT EXCEPT ... now i have an INDEX problem and my relationship doesn't see the "1" in the "Invoice OverDue" calculation since it references the Global field "Search Date" in the "Days OverDue" fields.  

 

HELP ... How can I build a relationship to my Invoice table so that it is current based on the CurrentDate and my Invoices that are late or overdue.  

 

When I tried clicking the "Always" Validate check box and use the calculation AutoEnter feature in the Validation Window it doesn't always validate, hmm??  It seems to only validates when the Field "Date Delivered" changes not when any data changes within the "Days OverDue" calculation changes like the global field "Search Date" which I am forced to use ... at my current level of thinking.

 

So what is the point in clicking "Always" in the Validation Window if it doesn't "ALWAYS" Validate.  The check box should say "Sometimes" Validate.  To me, if something says "ALWAYS" it mean always :-)

 

So any guidance here would be grateful.  I need a way to see my invoices that are over due when the application start and the only way I see NOW is that I'll have to GoTo Invoice Layout; Loop through Each Record and set the relationship field on each record with a one or leave empty manually through the loop.

 

Thank you.

 

Tom

[comment]

Why don't you calculate DateDue as a stored calculation, then use that as the matchfield against gSearchDate in a < relationship?