Thanks for the feedback, everybody.
I am not quite sure how better to describe my dilemma to avoid confusion, but I think you all get the gist. I have a rudimentary (but growing) grasp of relationships. I have been able to build a database that can gather patient info, create reports, create monthly reports based on those reports, etc. Right now, I am using one large table, with 500+ fields to cover every type of report we do. Here's what I understand as of now.
Pros - of using one large table
1- easy to show all related reports in one portal on the patient page
2- keeps the relationship outline pretty simple
3- My report layout seems simple, with only one layout needed to display any type of report. The different info for each report is stored in a tabbed section in the middle of the page, and depending on the report type, I automatically go to that particular tab
Cons - of using one large table
1- Possible waste of space (if, indeed, hundreds of empty fields in every record created DO take space, which it seems you are saying it won't)
2- Scrolling through 500+ fields to find the field I am looking for, no matter how well named and organized, is a little tedious.
It seems my major beef with using one large table is the ability to display all related reports in one portal. More and more people seem to suggest it's possible to show records from multiple tables in one portal, through relationship magic (probably not very magical once you know how to do it), although I have not been able to find a way to do this. Can someone suggest a resource to help me figure this out?