Hi!

How many records for a single address are in the child tables? In other words, is parent-child relationship "1 to 1" or "1 to many"? If second case, then what you're asking is just not possible logically, because View could not hold 1 records for address and several records for child tables at the same time. In such case you require to have 6 views: main view for Address, and 5 views for child tables. Child views could be parapetrized (parameter is ID of the parent record in WHERE condition), so you will nto download huge number of all child record, but only thous required. You will require though to use requery() for child views to get child record each time when parent table record is changed.

HTH.

>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