Are you sure that you need the extra table?
Did you know that you can enter find mode and enter ICU into the hospital location field to pull up all records for that loation?
What kind of analysis do you need to do with your data? (That will better help me understand what you need here.)
I was thinking it would be easier to just switch to a layout that displays what I want to see rather than going in to Find mode. I did set it up with a portal that displays what I need. I will probably also need to be able to do some summary reporting on some of the other fields (e.g., time between 2 events that are recorded.)
All that can be done. And the find can be automated. In fact, you can create a layout for this purpose and use a script trigger to run a find that pulls up the desired records each time you select that layout from the layout drop down or click a button that takes you to that layout.
Nothing wrong with using a portal, however, though summary reports will work best from a layout based directly on your original table here. It doesn't have to the the same layout, however. You can create a layout strictly for the purpose of your summary report.