I have a 4 million plus dataset. The main dataset is normalized with 9
What is the best way to display groups of these records?
I guess I am having two problems. I thought that creating a local view
would work but I keep getting errors. If I limit myself to 1000 records
and only try to look at a total of 3 of the tables, selecting all fields
and having two inner joins, then I do not get a correct display. Even
though one of the lookup values are changing the actual value from the
lookup table does not change. If I exit the view designer and reenter it,
I get errors about a specific column not being found and then all my data
That is my problem with views.
Then there is the original question about what is the best way to display
Actually I will never want to display ALL the records just some smaller