Trying to print data from multiple tables side to side on a reprot

[iukenny]

Hi,

I've been stuck on a report I am working on where I would like to list records from multiple tables into one report. Currently, my report looks fine when I am displaying other fields within the main table "tblProcess". The primary key that is being used is "Process_ID". The Process table has fields such as "Process Name", "Process Description", "Process Location", etc...

I have other tables (i.e. "Software Applications", "Websites") that the process ID is linked to. ) In my report, the report is sorted by Process Name alphabetically and then I list the other fields of the process table on the report. Right after this, I would like to list the applications right below, and the websites as well, but I cant get it to just show the applications and websites that are tied to just that one Process_ID.

Also to make use of space on my report, I want to put the data on these two different tables "websites", and "software apps" next to each other, but what happens is that it'll list all websites for one software app, and vice versa.

If anyone could help me out, I would really appreciate it. I'm a newbie to this site. Thanks!

 

[M8KWR]

are you using sub-report/forms in the report to pull the website and application information?