I normalized the data structure involved in recording test data into 4 tables that are essentially 4 drill down levels. One test tied to many reads, each read tied to many samples, each sample tied to many results.
It replaces a single table with 64 columns for entering data. My problem is the client wants the use the layout of the old form, 4 blocks of fields, each with 4 across and 4 down for data entry.
I'm looking for ideas on how to implement. I thought of using pivot tables but the data in pivot tables in not editable, right? So, won't work for data entry and editing. I also thought of creating an "on demand" a temporary table as the record source for views and edits and use the temp table to update the records in the normalized structure. But that seems both laborious and unwieldy.
I am reluctant just revert to the denormalized data structure because of ramifications for the rest of the project. Anybody else confront this and come up with an acceptable solution? Or, am I missing something painfully obvious?
elsuwi