0 Replies Latest reply on Mar 17, 2010 2:27 PM by mark_d2x

    calculation field



      calculation field




      I have created a lookup table to contain hospital numbers with the hospital, what I want to do is use the hospital number as part of a filepath for a container field.  there are 2 possible hospitals hospital A and hospital B


      the calculation should be:


      filepath A = server A s:\documents/hospital number hospital A.doc


      and for a second container field


      filepath B = server A\s:\documents/hospital number hospital B.doc


      I think the calculation should go along the lines:


      If (HOSPITAL_NUMBER::HOSPITAL = hospital A; 0; server A s:\documents/HOSPITAL NUMBER::NUMBER & ".doc")


      All the letters are word documents and new letters are appended to the end of the document so are dynamic documents.  Ideally, the letters should be viewable and even better editable within FMP.


      Any suggestions?