How To Display Records From Another Table Within A Report.

[JoeVilla]

Caspio newbie here 

 

I am building a report that pulls data from a view but I need to display multiple records from a table within a single page report. 

 

Example:

 

Common Data for the report:

Customer name 

Address

etc.

 

Section 1:

    Need to display records from another table in a list. There may be one or more records to display

 

1. Name      Description     Part number

2. Name      Description     Part number

3. Name      Description     Part number

 

Section 2

    Same requirements but different table and different info:

 

1.  Problem    Description    owner 

2.  Problem    Description    owner 

3.  Problem    Description    owner 

 

 

Any ideas on how I can do this?

[Jan]

Hello m2mexpert,

 

Welcome to Caspio forum!

 

I would like to recommend you to use the "Create a One to Many Relational DataPage" solution.

You can find also a video.

 

Does it work for you?

[NailDyanC]

Hello, just want to update this post. This is the updated link for Creating a One to Many Relational DataPage: https://howto.caspio.com/tech-tips-and-articles/how-to-create-a-one-to-many-relational-datapage/