>Could you give more details?
>1. What should the view do? How would the result look like?
The view should create a temporary table (cursor) linking all fields from all tables (excepting the keys). The result when have the same number of records as table 1, with the appropriate fields from the other tables.
>2. Should it will be updateable or just for browsing only?
Both.
>3. What is exactly the SQL statement for the view?
The SQL generated by the view designer is
select Parts.*, PartType.TypeDescription, CD.CDDescription, Location.LocName;
from Parts left join PartType ;
left join CD ;
left join Location ;
on Parts.Location = Location.Location;
on Parts.CD = CD.CD;
on Parts.PartType = PartType.PartType
This appears to nest the joins, so that the joins on location & cd are done just the once (ie all the resultant fields are the same) but join on part type works correctly (field match the keys from the 2 tables).
Hilmar gave an example of the SQL I would have expected to be generated (I haven't checked it works yet)
Thanks for taking the time to answer
Irene