Never mind I figured out the solution using the "substitute"
function. Of course after I sent the email : (
Hi Folks:
I have a print production database that allows me to create
production tickets for each print job we do as well as keep them
together as a package. Now I'm adding direct mail to the database
which may involve all or only a few of the parts of the print
package. I want to identify the individual pieces that will mail
using a common mail list. I have a check box field that can assign a
letter or ALL to the mail list and I can combine that letter to the
part number.
Looks like this: partnumber&mailcode = 09-1234-00A where A id the
mail code. But the part might be associated with more than one ,mail
list involved in the same print package. In other words there may be
up to five or six different mail lists that are made up of various
parts of the print package. Using a check box I can only get the
first letter to appear in the code and not all of the letters checked.
So what I want to do is create a number that reflects all the mail
list associated with that part of the print package. it might look
like this: 09-1234-00ABC.
Any ideas before I create 5 different fields for each of the possible
mail lists?
Thanks as always for your sage advice,
Peter
