Advice on views [message #529512] |
Tue, 01 November 2011 11:54 |
clancypc
Messages: 36 Registered: December 2006
|
Member |
|
|
Hi,
I am thinking of using views as a way of consolidating some data structures that I need to store. I have some data structures, 14 in total, that have some common elements between them, but also have elements that are unique to each structure. My first thought was to create a consolidated table of all the elements in all the structures, but that would leave for each record some wasted fields in each record. My second thought then was to store the data each in its own table (no wasted space) and then to create consolidated views using the common elements from each table. I would appreciate a second opinion on this train of thought.
If you need specifics on the data fields involved please let me know.
Thanks
|
|
|