>We're using views in a multi-user environment. We're finding that just loading the lookup views for a form can take a fair amount of time. But, yeah, otherwise, there would be no problem requerying the data when needed.
You should investigate what actually slowdown the views. It might be few areas to look for: tag on DELETED(), Rushmore in general, too 'view-generous' design approach. The latter one means that there is no reason to use view for the purpose of e.g. populating a combo: cursor will do this job faster. Also in many situations SEEK/SKIP cursor will work faster than view as grid.recordsource.
Surely, it's question of developer's preference.
Edward Pikman
Independent Consultant