I find myself needing to display data from 2 tables in the same portal, which means, I think, that I have a data structure problem. The application has People (PPL), Interactions (INT) and Attendances (ATT) in 3 separate tables. I need to show a listing of all of a Person's activity (i.e. all INT and ATT in date order - i.e. a "case history"), so, I need all INT and ATT records to be shown in the same portal.
Is there a clever way to pull it all together? I'm wondering about a virtual list, but probably the better bet would be to re-structure the data, with all ATT and INT records in an "Activity" table?
Any thoughts or suggestions much appreciated.