Well, Brent, the answer depends.

Unless you need to show the normalized data from the lookup tables in a grid or list with the parent, then you are probably better off leaving the parent table and the lookup tables as tables. Children off of the parent table might be parameterized views.


>I am one of those experts in 2.6 who keeps slipping back on the Visual learning curve. Can someone impart some wisdom, rules of thumb, etc. about designing views for a complex form with a main parent table, a couple of children, and many (10-15) normalized (surrogate keys) lookups.
>IOW Do I use/design basic parameterized views from each table and relate them or do one complex view that contains all the related data?
>What else should I consider when doing views for this moderately complex type of form?
>Any comments will be appreciated.
>Brent D. Smith