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