Combining selected data from multiple tables into another table in FM 10
I'm working on case management database. Each case consists of series of events, but each event has significantly different types of data. The differences between events make putting all the events into a single table too unwieldy. I've also developed a "case overview" layout that would really benefit from a portal that would contain an overview of all the events that have occurred in the case.
In order to get this done, I've created three fields common to all the events tables: Type (simply a text field that defines the what kind of event it is), EventDate (the date entered for the event), and Description (a short text statement entered by the user to provide a little context for understanding the event). I'd like each portal row to simply carry these three common fields along with a button to jump the user to the detailed record in the layout I've constructed for each event table.
I've tried several experimental things to try and come up with a way to create the overview portal but they've been pretty bad failures. Is there a way to funnel all of the individual event tables through another table to filter out the common Type, EventDate and Description fields so I wind up with a list/table of the events that I can turn into a portal on the case overview layout?
Any help would be greatly appreciated.