I have a situation where I have a parent table where I select a single record. Then there is a child table where there may be up to 50 records. Each of these child records is connected to a vendor. There may be several items in the child file from the same vendor.

I need to generate a report with the parent data at the top and then the child data listed below the parent data. Finally, at the bottom of the secton for that specific parent item, the vendor name and address for each vendor that was used. If there were 4 items from one vendor, then I want to list the vendor only once.

I can see how to list the vendors that were used in that report at the bottom of the report after all items are listed, but I want to list the vendors after all the child part records for the assocaited parent.

Any thoughts will be gratly appreciated.

Alan Maul
alan@lasere.com