AnsweredAssumed Answered

Creating serial letters...

Question asked by arminius on Oct 16, 2014
Latest reply on Oct 19, 2014 by taylorsharpe

Hello there,

 

i need to do a small wokflow and make a serial letter from filemaker.

 

I have 2 tables:

Table 1 contains the personal details of our employes.

Table 2 contains all information from our customers.

 

Now i need a layout where the employes can log in and define other employes based on regional definations.

 

f.e.

Region 1 contains all postcodes from 1xxxx to 1999

Region 2 contains all postcodes from 2xxxx to 2999

 

I define Member_1 to Region 1 an Member 2 to Region 2, now the system must create a letter with cusomer information and the personal information from the Members.

 

Next month i have new definations.... Now i have in postcode 1500 to 1600 a new Member_3

 

The system must only produce the serail letter where we have changes on it... mean all customers in postcode 1500 to 1600 and add there the details from Member 1 and 2

 

The tables will be updated weekly.... and the letters must also created weekly. The goal is it to reduce postcosts and create only letters where we have more persons defined themn the letter befor. In case that a member named on a erlier letter left the company we dont need to create a new letter. only when a new member join.

 

it is also neccesary that all letters created was accessable and that we can see the history.

 

How can i handle this?

 

Many thanks for for help and ideas.

 

I have here Filemaker 11 and 12 and work on a mac.

 

regards
Armin

Outcomes