106 fields in one table suggests you may have a problem that can be resolved by redesigning your data using two or more related tables. Feel free to post back with a description of why you need so many fields in one table.
Another thing you can do with the existing design is to create several layouts and place a subset of the total list of fields on each layout. This will at least allow you to see all the fields--though not all at once.
Thanks for that,
Its the width that is the problem, I didn't realize that.
I'll explain my relationships and you can tell me if there is a more efficient way of sorting it all out.
1) PATIENT ID(1 to many clinical presentations, and follow up )
2) Clinical Presentation (1 to many outcome measures, and complications)
3) Outcome measurements
The clinical presentation table is pretty long since there are alot of feilds that are associated with each other, as they are all the variables in a patient who is about to undergo surgery.
I NEED to have all those fields go together to a spreadsheet together for statistical analysis. Is there a way of getting all that data to a single spreadsheet in one fail swoop?