Relationships Question for Dates and Customers

[MarkSen]

Hi guys,

I'm having some confusion with my filemaker database. Essentially I have a table which has records of the customers that my company markets to. We send out flyers to our customers and I want to be able to track all of the previous dates that we have sent flyers to our customers.

What I've done so far is created a new table with records for each date that I've sent out flyers and related it to the customer table via the customer unique ID. I'm just confused as to how to add multiple customers to a single sent date and also how to add multiple sent dates to a single customer.

I'm having trouble finding tips on how to achieve this so any advice or direction would be fantastic.

Thanks.

[Agnes Riley]

You'll need to create 3 tables for this:

1. Customer

2. Flyer

3. Customer_flyer_join

In the join table you need to store both the customer and flyer ids for every record and the date a flyer was sent out.

You'll have to script the record generation. You'll need to decide whether you want to do this from the customer or flyer layout first.

[MarkSen]

OK I will give that a shot.Thank you! Seeing as we send out thousands of flyers a month, the join table is going to get quite large. Will that affect the overall speed of retrieving files from other tables?

[Agnes Riley]

FileMaker can store an insane amount of data. The join table will not hold a lot of information just the basic data table fields (date created, modified, created by, modified by) and the two IDs and the date sent if it needs to be different. So I wouldn't worry about this.

I have no idea what "files" you are referring to. So, please specify that.