View Single Post
  #1   Report Post  
J Guerry
 
Posts: n/a
Default Mail Merge from Access - How to retrieve linked data with a one to many relationship

Using Word2003 to merge data from Access 2003. I need to merge data from
three tables:

Customers
Orders
Order Items

I have succesfully meged linked data from the Customers and Orders tables
(one record each). However, I need to merge multiple records from the Order
Items table. Is this possible?

Thanks,

Joe Guerry