Multiple Queries to 1 Detail Entry

[lotharious]

I have 3 SQL queries that have completely independant data that I need to put into 1 detail entry on my report. I can not, without putting in a middle process, get the data to be in 1 query. Is there a way to get the each first record, second record and so forth to show up in the detail of the form?

 

[Madawc]

Which Crystal? In Crystal 10, you can link queries as if they were regular record tables.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lotharious]

This is 8.5
Someone else pointed out that I can do this by making sub reports, so I am trying that now. But having issues getting my data into the report because my Access Query is using a custom function.

 

[Madawc]

In 8.5 you do have to use subreports, even though they are inefficient. As for Access Query, if that's a problem the please start a new thread about it.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10