Very Computer

I have a 4 million plus dataset.  The main dataset is normalized with 9
lookup tables.  

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
is lost.

That is my problem with views.

Then there is the original question about what is the best way to display
records........

Actually I will never want to display ALL the records just some smaller
subset.

Help please

Thanks
Carl

Parameterized views are the way to go.  The View Designer is somewhat
limited.  You might
achieve better results in code.  For the lookup tables you might use
calculated fields in your grid.

--
Jos Constant
Constant Software Systems

http://www.club.innet.be/~year2396/

Quote:> I have a 4 million plus dataset.  The main dataset is normalized with 9
> lookup tables.  

> 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
> is lost.

> That is my problem with views.

> Then there is the original question about what is the best way to display
> records........

> Actually I will never want to display ALL the records just some smaller
> subset.

> Help please

> Thanks
> Carl

Carl, where is this 4 million record dataset?  Native VFP tables on your
workstation?...on a file server?  Or in a data warehouse managed by a
separate server such as SQL Server or Oracle?

Quote:> I have a 4 million plus dataset.  The main dataset is normalized with 9
> lookup tables.  

On my workstation in Native VFP dbc