>Hello Hilmar,
>
>I have never used views. If you don't mind could you give a workable example or link? I will look myself at some examples in vfp help.

Well, although you can read the VFP manuals, I think there is no substitute for experimenting.

Did you use queries? If you didn't, you should start with the query designer:

CREATE QUERY

or

MODIFY QUERY

This will create a program with extension .QPR, which you can then run with DO (or you can copy the code to another program)

Try some simple experiments first, and then more complicated ones:

Select specific fields from a single table.

Add a filter condition.

Combine data from two tables.

All this will create a read-only cursor - you can't update the original tables. If you already did all this, we can continue with views.

Greetings,

Hilmar.

Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)