My question is as follows:.
We are using FIlemaker Server and FIlemaker 6.0 for our clients.
Ocassionally, we have records that we know were in the database the day before disappear and no where to be found.
Also, some of our dates change automatically and we don't know why.
For example: We have a field called INvoice sent date which is a calculation- If (Invoice sent = "X", Today," ")
We actually put an X in the invoice sent field which the trigggers Invoice sent date.
The field option do not evaluate if reference field is empty and we have indexing on.
I didn't think that the today function recalculates each day. We use the invoice sent date to perform other functions and do not want it to recalculate each time program opens?
DO you have any suggestions? APpreciate your help