The tables I am speaking of are BE tables.
The 40+ fields are my data input by users (e.g. Order Number, Cost, Date, Project Name, etc.). I have various reports that I'd like to run on this data and I feel that my "report form" is confusing as it is today. I think what I am going to do is...