duncs Posted February 5, 2006 Posted February 5, 2006 I'm sure there is an easy answer for this, however, I am a real newbie, and am struggling with what to do. I want to change a letterhead on a form letter layout, based on the contents of a field in the main database layout. The field contains the letter writers name, and is either "user a", "user b", or "user a & b". I think I need to create a calculation that will take one of the 3 graphic letterheads (each of which is stored on the main database layout in a global file labeled "user a letterhead" "user b letterhead" etc.) and insert it into a container on the layout. Can anyone help me with this??
Genx Posted February 5, 2006 Posted February 5, 2006 ... fairly straight forward... make a calculation field with result container to hold your final letterhead...then as the calculation just do...also, feel free to set the calc field to unstored though its not exactly necessary it'll save you a bit of room... Case( userfield = "user a" ; user a letterhead ; userfield = "user b" ; user b letterhead ; userfield = "user a & b" ; user ab letterhead ) genx
comment Posted February 5, 2006 Posted February 5, 2006 It will be forced to be unstored in any case, as it references a global field.
duncs Posted February 5, 2006 Author Posted February 5, 2006 Thanks very much for your help, (it worked needless to say!) Expect to here more from me!! Thanks again
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now