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?