Yeah, anytime you have a table with a large number of records and you want to see all its records (or most of them at least) a view is not an optimal solution. A view is great for a child table like the line items on an invoice where you're only retrieving the line items for a single invoice and all the other jillions of line items for other invoices are ignored. VFP can get that data in no time. But to use a view to select all the records from a table - especially a large one - is not normally recommended.


>OK, so I created a view. One table is tiny, but the other is rather large as most of our tables are. When I browse the created view, it runs a query for about a minute or so then pops up. Is that what would happen if I used the view in a form? would it really take all that time to query each one? If so, that is way to slow and inefficient for us to use that method with our large tables.