Mail Merge: One to Many Relationships

[trifest]

I'm trying to perform the following for one-to-many relationships from multiple tables within Access. Here's the article I'm looking at

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnovba00/html/MailMergePartII.asp

Is there an easier way to go about this as this article is not that comprehensive. Thanks for the help

 

[trifest]

Here's some more info. I'm using the following field
{ Database \d "C:\SATv14.mdb" \c "DSN=MS Access Database;DBQ=C:\\SATv14.mdb;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;" \s "Select 'System Name', 'Control_ID' FROM 'tblTestCaseStore'" \h }

Did I do something wrong here. Not quite sure what all the parameters mean but trying to figure it out. Thanks for the help.

 

[SkipVought]

Hi,

just taking a stab.

loose the double slash

DBQ=C:\SATv14.mdb

Not just tics

"Select `System Name`, `Control_ID` FROM `tblTestCaseStore`"

Skip,
[sub]
[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive! [/sub]

 

[SkipVought]

oops!

I believe that you need the double slashes.

So we're down to the tics.

Skip,
[sub]
[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive! [/sub]

 

[trifest]

It's weird because I'm not sure exactly what's going wrong. The error messages are so vague and not directed that I can't debug it correctly. Anyone else have any thoughts? This is driving me crazy.