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.

I have users who want to see data when they enter the form( Why, I don't know why?!?!?!) so a PV only works after theyhave been presented with data to allow them to narrow their search. Right now, since we have not converted old data and the test phase has not completed, the grids work fast. I have warned the users that when the converted data gets in and they have to do data entry that their form will be slower than molasses in the North Pole in winter.

QUESTION: I have not tried this myself but would like to know if you have. If you create a view that is updatable and include the lookup fields but don't include them as updatable, don't you have to create a custom save routine to save the key value into the view with REPLACEs?

QUESTION: I have not tried this myself but would like to know if you have. If you create a view that is updatable and include the lookup fields and you include them as updatable, won't your lookup tables get updated as well as your base view?


Michael Haggerty
AMK Systems, Inc.
amkhag@erols.com