Hello,

I'm looking for information on the creation and use of views as a data source in a form. What are the benefits, how do they impact performance, what are the prerequisites for using them, parameter views, etc., etc.

Currently I'm using set relations in the load event of my forms, but am interested in converting to the use of views, but I have no experience and would like to see some real-world examples of how they work.

Our main form uses 9 tables and I thought a updateable view would be something I should be looking at for this form:

select master
set relation to acct_no into accounts
set skip to accounts
set relation to comp_no into ownpct additive
set relation to comp_no into mastnote additive
set relation to syn_acct into syn_mem additive
set relation to comp_no into hftrns additive
set relation to comp_no into breedlist additive
set relation to comp_no into breed additive
set relation to comp_no into health additive
locate


Thanks