AnsweredAssumed Answered

calculation field

Question asked by mark_d2x on Mar 17, 2010

Title

calculation field

Post

Hi,

 

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?

 

Mark

Outcomes