Hi NG,

I'm not very familar with views and I need a little help to create a special one in VFP 7:

I have 1 mastertable called ADRESS and a few (Ithink 5) tables with related information with n-records to each adress.

Now I want to create a view programmatically where I have my ADRESS related to each of the other tables. All tables have the ID of ADRESS and an index onto this ID.

I have problems with the syntax and can't figure out how I can do it.

The result should be a view for 1 ADRESS record (where...) with all the records of my other tables for this adress.

Thanks in advance,

Stefan Zehner