Help With Report Layout (Sub Summary?)

[NickFaraday4]

I'm having an issue creating a report, hope someone can help.

Ok so here's what I'm trying to do:

I have a List of Records (say list A), then I have records in another table (: that are related to list A. I want to display of list of records (list A) and under each record, that records related info.

Example.

LIST A

TREE

BOAT

FISH

CAR

Related Records in Table B

TREE BARN

TREE SKY

TREE WATER

BOAT BARN

BOAT SKY

CAR PAINT

SO I want to build a report that shows

TREE

- BARN

- SKY

- WATER

BOAT

- BARN

- SKY

FISH

CAR

- PAIN

If I use Table B as the layout source I wont get record "FISH" in the final report because there is no related "FISH" record in table B.

Thanks in advance

[comment]

See:

http://fmforums.com/forum/topic/55833-printing-related-records/page__p__263679#entry263679

[NickFaraday4]

  On 12/17/2010 at 1:03 AM, comment said:

See:

http://fmforums.com/forum/topic/55833-printing-related-records/page__p__263679#entry263679

LMAO ok, so a portal with 1000 rows... looks like that works. Thanks