Understand the Mailing List v4.1 Program

ML4v1.fp3, MLbusnv1.fp3 and MLpersv1.fp3 are the "primary" files of the Mailing List program. They are linked via relationships. Through this "link" each file can access the other file's data for sorting, printing, calculations, etc..

Let's use an example to see how this works. George Smith is the owner of a small greenhouse and is on our Greenhouse (GH) and Master Gardener (MG) lists. We have both his business and home addresses. Mail for the GH list goes to his business. Mail for his MG list needs to go to his home. In the program his data (his records) will be broken down as follows:

  • mailing codes, race and gender are stored in a ML4v1.fp3 record.
  • company name, business phone & business address are stored in a MLbusnv1.fp3 record.
  • name, home address & home phone are stored in a MLpersv1.fp3 record.

Why do this? FileMaker Pro is more efficient when it can store data is separate, smaller files than in one large file. Also, having separate files means that future upgrades to the program can target a specific file (MLbusnv1.fp3 for example) while leaving others alone. Does this mean YOU need to keep track of the three separate records (one in each file) for George? No, no, and no. As you'll see, all three records are accessible from ML4v1.fp3, the "main" file of the program. If you have business info to add for a record, you add it to a Entry Screen in ML4v1.fp3. When you do, a record is created automatically in MLbusnv1.fp3 through the "relationship" between ML4v1.fp3 and MLbusnv1.fp3. When deleting a record in ML4v1.fp3, any "related" or linked records in MLbusnv1.fp3 or MLpersv1.fp3 are deleted as well. You'll understand more as you begin to use the program. Remember for now that these files are linked. You only need to open and work with ML4v1.fp3. The other "related" files of the program will open when needed and simply work.

To download a new copy of the Mailing List v4.1, go to Mailing lists database and follow instructions.