I need to make a report which consists of three fields of three different databases.

I want to see on my report

1) the name of the job (1 record)

2) the knowledge you need for this job (several records)

3) who does the job (several records)

So it should look like this:

1

2a

2b

2c

...

3a

3b

3c

....

"next record"

I can't seem to get this report right. I succeed in getting the first two levels right, but I can't show all the persons.

Thankyou for reading and eventually answering my question.

Mich

This is one of those rare situations where you will need to use portals in your report. It's generally not recommended because they don't print very nicely. However, the way your data is grouped, I don't see any other way. In your job database create a report layout with the job info 1, a portal to the knowledge database 2, and a portal to the person database 3.

This may seem more convoluted, but perhaps you could set up a separate report file, where one record = one line of the report. Data could be transferred by script from each of the three databases, sorted in the report file by Category (Job Info, Knowledge, Person), printed, and then deleted.

Sound plausible?