8 Replies Latest reply on Nov 5, 2013 10:00 AM by AnthonyTesoriero

    Calculation based on value list from related record



      Calculation based on value list from related record


           I have about 8 hours invested in attempting to figure out what should be a basic calculation but I'm now at the "throw something through the screen" level and asking for help...

           I have 2 date fields called "date of notice to owner" and "date of notice to lien-holders".

           The date of both will always match however while there is always an owner there is not always a lien holder therefore I need the field to populate based upon a calculation.

           All lien holder and owner records are contained in a related database and defined by a "type" field to distinguish them.

           "Date of notice to owner" automatically fills in based on a different calculation call "auction date" 

           I need the proper formula to get "date of notice to lien-holders" to fill in automatically or remain blank based on whether or not a record does or does not have a related lien holder record.  

           I've tried "If" "Case" "is Empty" "Evaluate" logic expressions based on text and numbers. I cannot get the filed to work in a manner that it auto populates and or erases if lienholder have been deleted.  

           Thank you in advance for your help