How to set a portal from multiple tables?
I apologize if this is too much information but I am still learning and want to give enough information.
I have 7 tables (Companies, Contacts, CD Notes, CSG Notes, Company News Notes, Legal Notes & Attachments) and want to have a tab with a "Journal" portal that would scroll all the notes from the listed tables. My IT guys are not much help on this as they refer to SQL and say "Query" but I am not finding a query for FM.
We I try to build a portal I notice it will only let me pull from one table...any suggestions would be appreciated.