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.
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.