Report to display one to many relation

[swebs]

Database Layout:
Table A:
AFieldID
AField1
AField2
AField3

Table B:
BFieldID
BFieldAID (linked to AFieldID in TableA)
BField1
BField2
BField3

There are multiple entries in Table B per main record in Table A.

I cant figure out on my report how to get a list of all the records in Table B associated with each specific record in Table A.

I would like the report output to display each record in A and then the specific records in B. then the next record in A and its specific records in B... etc.

Any help would be appreciated.

[Rabbit]

Use an INNER JOIN to join the tables.

[Mihail]

Use a subreport .