Hi, I was hoping to get some guidance on this design.
We have a large customer annual review that we need in relational format. Currently, it's in a spreadsheet with 50 rows and about 10 supporting columns. Rather than create one large table with all 500 values necessary for query I wanted to break it out into 10 tables broken up by category. I have those tables tied together through lookups and master/detail - no problem so far.
However during entry it would be incredibly helpful to render the entire 500 field review in a single form. With master/detail we have the data "there" but each item of detail in the master/detail looks pretty clodgy with all 50 data items on that one table. Since we're sitting down with clients to review these / edit these real-time we'd like it all on one page where we could scroll up/down with them rather than click around into very wordy looking items.
What would be you guys recommendation?
We have a large customer annual review that we need in relational format. Currently, it's in a spreadsheet with 50 rows and about 10 supporting columns. Rather than create one large table with all 500 values necessary for query I wanted to break it out into 10 tables broken up by category. I have those tables tied together through lookups and master/detail - no problem so far.
However during entry it would be incredibly helpful to render the entire 500 field review in a single form. With master/detail we have the data "there" but each item of detail in the master/detail looks pretty clodgy with all 50 data items on that one table. Since we're sitting down with clients to review these / edit these real-time we'd like it all on one page where we could scroll up/down with them rather than click around into very wordy looking items.
What would be you guys recommendation?