Summarizing Fields from a portal into the Parent table

[Kimmie]

Hello Everyone,

I am in the process of creating a database for a Tradeshow that we host and

I am having a problem with creating a report that contains totals from 2 different portals on one layout. I have searched for an answer in the forums but being self taught I am still confused. I believe a have to create a self-join? but have no idea how or what tables to use, etc. Right now, I have a parent table (main) that contains all contact information. I then have a portal for booth space sales and a second portal for all other sales. Since we do the show once a year, there is a year field and for all the sales, it is linked to another FM database for pricing and items sold. I have created summary fields per salesperson/show year/and sales item and as long as the field is in the proper layout it works fine. I want to create a report that will show the summary fields from the 2 separate portals in one report. If you need any further information I will certainly comply. Thank you in advance for any help with this!