creating report with subdatasheet information, help.

[nemmeh]

Hello everyone, hope everyone is having a nice day. I need a little help plz.

I have two tables, which are "Venire" and "Voter".

I have "Voter" linked as a subdatasheet to the common field between the two of "JurorNo". Is there a way to create a report that will display the information in the Venire and Voter tables into 1 report?

For instance, table "Venire" contains a persons (Name, Address, City, JurorNo) and table "Voter" contains a lot more detailed information about each person, for instance (Ward,Pct,Address,City,JurorNo).

I need to be able to create a report that will list each record in the "Venire" table, then on a subline it also list the information about that person that is contained in the "Voter" table.

Is this possible? I'm sure it is.

Any help is surely appreciated, thank you.

 

[nemmeh]

hehe n/m everyone.. I had a brain fart... For some reason I just didn't think of the simple solution of creating a query that displayed the results of the two matching fields. Duh! then selecting which fields I wanted to be displayed in a report.