I am redesigning a number of 'straight' IJC databases into relational versions that will need to rely on Form Views in order to be able to see data from multiple tables simultaneously. However, the users I am catering keep telling me that they still would like to see a spreadsheet-type table which summarizes SAR from different assays for multiple compounds (not an unreasonable request imo). I can imagine this is possible by compiling the most important parameters using Calculated Fields into a sepparate Summary table and visualizing it through a Grid View (I could even show the structures here by rendering smiles as structures), but the data will not be sortable (which is also critical to my audience and me).
Is there a better solution? I hope you understand what I want to achieve. Observe that I am using the local Derby format.