Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Design Problem


Vin

This topic is 8360 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Please help,

I am having a very basic design problem which I just cannot get my head around, I have a sytem off about 10 files - Contacts,Invoices,Projects,Images,etc.

Problem: I need to be able to set up a mailing database related to the 'contacts file' by 'contact Id', I need to store details of the mailing ie. mailing history .What if I make each record in Mailings equall a seperate mailling and show all the contacts in a portal does this sound sensible or am I missing something, I would also need to "mark" the records in the contacts file.

Assistance greatly Appreciated

Vin

Link to comment
Share on other sites

The reason you are having trouble is that the relationship between contacts and mailings is "many-to-many". Except for a few tricks, FM and other database programs cannot directly implement many-to-many relationships, they must be decomposed into two one-to many relationships. The classic example is students and classes. A student can be in many classes and a class can have many students how to relate the two entities?

The solution is to add two additional files. In the first file a record is a mailing. All the information about the mailing is stored here, the data, what the purpose was, what material it contained, the postage per piece, etc. The "marking" of contacts in the mailing is done by creating a "join" file between contacts and mailings, in which a record is a contact/mailing. You have now decomposed the many to many relationship between contacts and mailings into two one-to-many relationships, one between contacts and the join file and the other between mailings and the join file.

You can think of each entry in the the join file as a single piece of mail. The size of each entry is minimal as most of the interesting informtion about contacts and mailings is in the other files. The join file just associates contacts and mailings.

-bd

Link to comment
Share on other sites

This topic is 8360 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.