All:

We are about to change from using related single-table views to populate grids to using a single multi-table view and dropping the relations. Since Version 5.0, relations have seemed to grow more and more fragile to the point that we have reluctantly concluded that they are no longer an option as grid data sources.

My question relates to adding a deleting records to multi-table views. Can I add a record to the view itself or must I add to the underlying tables and REQUERY() the view each time a record is added? If the view contains 40,000 or so records, this could take some time.

For deletes, the same question. Can I delete a record from the view, or must I delete from the underlying tables then REQUERY().

Thank you,