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.