Mail Merge Report

[knowshowrosegrows]

I am having trouble getting my head around the tables I would need to produce
the following document.

I have two hundred agencies that each get a letter.
There are nine categories of one-time only funds that they might be eligible
for.
So agency A gets fund categories 1, 4 & 7. Agency B only gets funds 3.
There is aspecific paragraph that goes in the body of the letter that
explains each of these 9 categories of funds.
So Agency A's letter will have paragraph 1, 4 & 7 and agency B will only
have paragraph 3.
In my muddy thinking, I know I need a table of agency info and a primary
Agency ID.
I also need a table of paragraphs (memo fields) and a primary Paragraph ID.
Do I need a table that combines them together that has a "Combo ID" as
Primary and the Agency ID and Paragraph ID as Foreign?
The relationship between Agency and Combo is One to One?
The relationship between Combo and Paragraph is One to Many?

So, what kind of form would I build to input these records?

 

[DanielWalters6]

Hi, I've had a little play with a database to try and do what you're trying
to....

Drop me an email dan[at]gadgetsolutions[dot]co[uk] and I will send to you...


Dan Walters