Make Table Query for Mail Merge

[RomeLaw]

I'm pretty new to access. I'm trying to set up a database that I can easily use for a mail merge in Microsoft Word 2003. These will be court documents/pleadings. I'm having trouble trying to figure out how to create a Make Table Query including the relevant information for the purpose of the mail merge.

TablePlaintiffInfo

1. ID (Autonumber)
2. PropertyName (Text) (e.g. Manor Hill Apartments)
3. PropertyAddress1 (Text) (e.g. 244 Able Dr.)
4. PropertyAddress2 (Text) (e.g. Columbus, Ohio 43215)
5. LandlordName (Text) (e.g. R.F. Hillman Trust, Inc.)
6. LandlordType (Text) (e.g. an Ohio Corporation)
7. DoingBusinessAsName (Text) (e.g. d/b/a Manor Hill)
8. PropertyManager (Text) (e.g. Christy Hollingsford)
9. CManagment Entity (Text) (e.g. Acme Management, Inc.)
10. CourtCounty (Text) (e.g. Franklin)


* This information primarily stays the same, but at times I might need to update this individual property’s field and/or add new properties. It should be noted that there can be multiple Landlords under one property name. Each Landlord will have their own entry. There will only be one Landlord per case.

TableDefendantInfo
Defendant (Tenant) being evicted.

1. DefFirstName (Text) (e.g. Megan)
2. DefSecondName (Text) (e.g. Ableman)
3. (possible) Def2FirstName (Text)
4. (possible) Def2SecondName (Text)
5. (possible) Def3FirstName (Text)
6. (possible) Def3SecondName (Text)
7. (possible) Def4FirstName (Text)
8. (possible) Def4SecondName (Text)
9. (possible) Def5FirstName (Text)
10. (possible) Def4SecondName (Text)
11. DefAddress1 (Text) (e.g. 313 Minute Rd.)
12. DefAddress2 (Text) (e.g. Columbus, Ohio 43215)
13. AmountLateRent (Text) (e.g. $780.00)
14. CaseNumber (Text) (e.g. 2011 CVG 39209)
15. HearingDate (Text) (e.g. May 27, 2011)
16. I need a field where a Plaintiff’s information can be selected based on choosing an ID number from TablePlaintiffInfo.

* This information is new with every case. I’ll need to enter all this information with each new case. Additionally, there are varying amounts of defendants. Language in the documents will need to reflect the amount of Defendants included.

* I’ll need to be able to update this information as the case goes forward. The CaseNumber and HearingDate will no be available upon initially entering the TableDefendantInfo.

Make Table Query

TablePleadingInfo

1. DefFirstName (Text) (e.g. Megan)
2. DefSecondName (Text) (e.g. Ableman)
3. (possible) Def2FirstName (Text)
4. (possible) Def2SecondName (Text)
5. (possible) Def3FirstName (Text)
6. (possible) Def3SecondName (Text)
7. (possible) Def4FirstName (Text)
8. (possible) Def4SecondName (Text)
9. (possible) Def5FirstName (Text)
10. (possible) Def4SecondName (Text)
11. DefAddress1 (Text) (e.g. 313 Minute Rd.)
12. DefAddress2 (Text) (e.g. Columbus, Ohio 43215)
13. AmountLateRent (Text) (e.g. $780.00)
14. CaseNumber (Text) (e.g. 2011 CVG 39209)
15. HearingDate (Text) (e.g. May 27, 2011)

*The information below would be based on the selection of the particular Plaintiff via their ID when filling in the Defendant's Information.

16. PropertyName (Text) (e.g. Manor Hill Apartments)
17. PropertyAddress1 (Text) (e.g. 244 Able Dr.)
18. PropertyAddress2 (Text) (e.g. Columbus, Ohio 43215)
19. LandlordName (Text) (e.g. R.F. Hillman Trust, Inc.)
20. LandlordType (Text) (e.g. an Ohio Corporation)
21. DoingBusinessAsName (Text) (e.g. d/b/a Manor Hill)
22. PropertyManager (Text) (e.g. Christy Hollingsford)
23. CManagment Entity (Text) (e.g. Acme Mngt, Inc.)
24. CourtCounty (Text) (e.g. Franklin)

 

[Guus2005]

What was the question again?

You provide a lot of information. I am sure that every bit is needed to complete the question you have.
My advice to you is keep it simple stupid or KISS in short.

First provide us with a little bit information to keep the crowd interested.
When asked, provide the rest of the information.

I'd say, please try again.

HTH

 

[RomeLaw]

How do I execute a Make Table Query where information included in the new Table from TablePlaintiffInfo is -based- on information entered in TableDefendantInfo (e.g. a field in the TableDefendantInfo where you can enter a number correlating to the Plaintiff ID# field, thus choosing a particular plaintiff's information).

 

[Guus2005]

For readability you might want to add some returns. I'd had to read it three times to come to the conclusion that i don't get what you want.

The first part is easy.

currentdb.execute "Create table TableName (Field1 integer, Field2 text(255))"

Just trying to help

 

[Guus2005]

Slowly it is sinking in. I think that what you need is a proper database design and not a make table query. Unless you want to create a tables on-the-fly.

HTH