Exporting related files

[B. Keith]

I am trying to publish (in book form) data I have collected in three related databases.

db1. list of 17 bulbs

db2. the 40 divisions of the above 17 bulbs

db3. the varieties in each of the above 40 divisions

The database works great for etering and searching but I am now trying to export and merge the data. What is happening is that I can't figure out a way to export the related fields in the the approptiate order

Dahlia

Div 1

Art Deco

van Gogh

Div 2

Big Red

Big Blue

etc.

What I am getting is the first related variety in each division and the rest of them at the end like:

Dahlia

Div 1

Art Deco

Div 2

Big Red

van Gogh

Big Blue

etc.

I am struggling with the methodology here. I essentially want to export all the contents of a portal with the related record before moving onto the next record. The long term goal is to be able to do merges in Word or Pagemaker and create catalogues with text styles and image links automatically in place.

Any ideas or hints?

Bruce