>How do you guys use only views in these scenarios:
>
>1. a parent table (20000 recs minimum search) with 6 lookup tables displayed in a grid
>
>2. data entry using the above.

You can have more than one view in a data environment.

If they insist on seeing data when the form comes up, as opposed to haveing them come up with some type of view paramater, you come up with one.


TOP 100

Created within the last 10 days

upper(left(LASTNAME,1)) = 'A'

Then, the pick list will be incremental... Every time that the user enters another letter for the last name search, or ssn, or whatever, add that to the view paramater field and requery the view.

Also, you can have seperate views for the lookups that are paramerterized...

vp_Orders = _screen.ActiveForm.CustId

This use vp_orders as the view param for your orders view.

Always get the LEAST amount of data you can, and only query data when you HAVE to show it to the user.

BOb