>Here is the thing.
>
>First you should know that I am working with VFP 3.0
>
>I want to make a view. That view is to be made of data defined in a table but referenced in another table
>
>The thing is that if the field contains something I want the view to return the data according to the reference. The problem is that the reference can be empty. In that case I want to see an empty column on the view.
>
>I am clear enough?
>
>How can I do it?
Do you want to use LEFT OUTER JOIN? I'm not sure that VFP3 designer supported it. If you can live with cursor then it's not a problem.
Edward Pikman
Independent Consultant