Exporting Portals

[veramilo]

I have a very basic file that I use to publish a categorized directory listing. It has two tables:

The main table contains the company name, address, phone, etc. (around 300 records), and the other table contains the categories of products carried by each company with a different record for each category from each company (records related by a company code number; around 1,500 records).

Also in the main table, I have a portal that I use to select and display each company's related categories.

I need to export each company's directory listing data along with all the product categories they carry -- all in a single file -- but I can't for the life of me figure out how to do it.

It doesn't matter too much how the categories are listed in the export but I'm hoping they can be all in one field separated by any character that I can later change to a return in my Quark print layout.

Can anyone point me in the right direction?

Thanks!

Vera