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

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 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 read-only p-views, creating them 'on the fly' keeps the DBC a little smaller and faster.

HTH
Barbara


>David,
>
>Do you create the p-views in a prg that runs before the form?
>
>Does it get added to the database?
>
>What is .fk and .pk?