>I am trying to deploy an application currently with vfp tables to Mysql,
>but have the following questions
>1. i suppose all tables in mysql has to have a corresponding view
>2. what about tables that can be viewed individually or as child data of
>other table, how is the parametrized view set and how does the 1 to many form can send the parameter to there.
>3. when is a good option to parametrize a view and when to use a whole view
>for a whole table and manage as a vfptable ?
>
>thank you all
>
>Regards
>Norman Avila

Hola Norman,

The main purpose is try to avoid as much network traffic as possible.
So I would limit the use of non parameterized views to lookup tables. These lookup tables might as well be in a local DBC.

For the parent table, I would allow for several parameters, in order to help the users narrow their search, bring them to a grid and make their final choice there.

For the child table, there would be only one parameter required, that is the parent key.


HTH.

José