[Rik Brown]

Originally Posted by Marco van Herwaarden

Why are you creating a view?

Because a view will allow me to "view" the database in ways not available through vb.

For example, I can load 1,000 (or more) rows of information into what looks almost like an Excel spreadsheet and pagedown or pageup through that data quickly to exaimine data that matches criteria that I cannot define within vb.

The view gives me much more control and speed than one can have going through vb as the frontend to the database. Plus, its simply time I expand my knowledge of mysql and learn more above constructing views.

Regards. -- Rik