How to add user input data to some fields in crystal reports using push method with other relational tables

I have a crystal report file with header and footer placeholders. The report is connected with 3 tables. 2 tables are connected with foreign key and the 3rd table is only information of the company or other data which will be get on runtime from user acquired and in DataSet saved. How can I join these three tables. Because it refuses to put tables on one report without relationship between all of them.

Need some more guidance on what could be done here to achieve this.

Thanks.

Solution

One option you can try is to use Sub reports.

Take the table that is isolated in sub report and other two tables that are connected with foreign key in main report.

By this you can solve the issue.

Let me know if you need more information.