sherricoffey Posted March 23, 2009 Share Posted March 23, 2009 I have been trying to figure this out since the middle of last week. Any help would be appreciated! I am using three files: my main data file from which I am referencing two fields (STOREID and ADVISNUM), a dealer information file that ties to the main data file by the StoreID field (there is only one record per StoreID in this file), and a service advisor file that ties to the main data file using a StoreID field and an AdvisorNum field (there could be multiple records for a StoreID, but only one record for each StoreID and AdvisorNum). The signature block needs to flow in line with a letter and have a picture of the service advisor (sized to about 1" x 1.25") (if it's available) (which I need to create the resource dynamically) with the Sincerely, and service advisors name, title and phone number next to the graphic. My customer will be Supplying me with pdf files of the service advisors using the following naming convention: STOREID_ADVISNUM.pdf. I have an images directory that I will be placing these in. If the graphic is not available (meaning I have no pdf file in my images directory that matches the STOREID_ADVISNUM.pdf for that record), then I need to return the Sincerely, and service advisors name, title and phone number from the service advisor file at the left margin of the letter. If there is no service advisor number in my main data file, then I need to return the manager information from the dealer information file. I also need to return the manager information if the service advisor number in my main data file does not match any record in my service advisor file. I also need these signature blocks to flow in line with the body of the letter so they need to be inside the text box that is the body of the letter. Link to comment Share on other sites More sharing options...
This topic is now archived and is closed to further replies.