>John, I'm not David :-) but if you keep in mind these are MY opinions....

And your opinions are valued here...

>
>PK is Primary Key and FK is Foreign Key. To be REALLY basic (for any newbie reading this) the Primary Key is the unique identifier for each record. A Foreign Key is the COPY of this key that links one table with another. A Child table will have its own PK, plus FK values from the Parent Table. There can be many identical FKs in a table.

As soon as I read "Primary Key" I knew what he meant... but sometimes it is not as clear right now as it might be in the future...

>
>As for creating p-views, if they are updateable, the view goes into the DBC and is called like a table with 'USE MyView' in a form. If you haven't set the parameter(s) VFP will ask you for them (not a good idea from the user point of view).

For updateable views... will they update the table if send sql update is checked? If so I must be doing something wrong as when I run the form it will update the view ok but not the table that the view is based on??? Did I miss something???

Do you add the view to the dataenvironment? or do you do a use in the load of the form?


Thanks