If I setup a table of employee names and made a relationship to my cases table. how easy is it to write a script to grab each portal line lets say,, firstname, lastname and write a script to grab each portal line and place it into the form letter I have created. Would that be the bestway to go.
Create emplyees table and place a join table between it and the case table and just print the records created in the join table to the form letter? Am I headed down the right path? Will this cause to many records in my database? how many records can FM store?
If you set up the form letter on a layout based on the portal's table, this can be very easy to do.
You can use merge fields to construct the form letter, or you can use a text based "template" method for producing customized messages: http://www.4shared.com/file/Z36UjVOL/MessageTemplateBuilder.html