Flatten Normalized Data in Access 2000

[Dan]

I need to know if there is anyway to creat some kind of
local veiw/table, that flattens out data that has been
normalized accross 4 tables, that I could then call from
another query.

 

[Immanuel Sibero]

Hi Dan,

Not sure what you mean by *flatten out normalized data*. I'm going to assume
that flattening normalized data in this case means *denormalizing* the data.
If this is the case, well... that's what queries do.

Anytime you build a query using a set of normalized tables and the
relationships among those tables, you're essentially denormalizing the data
from the normalized tables. If you want the resulting denormalized data in a
table, then build a Make-Table query.

Tell a little bit more of what you're trying to accomplish. I'm not sure I
understand your question.



HTH,
Immanuel Sibero