Hi All.

I have just converted an app started in VFP 3.0b to 5.0a. I am trying to set up a local view, and the documentation in the on-line help on JOIN conditions is awful! Can I do the following in the view designer? Or will I need to create the view in code?

I have a table of contacts. Its PK is Co_Key. It also has 2 FK's, Co_Cl_Key and Co_Fa_Key. If it is a client's corporate contact, Co_Cl_Key is some non-zero integer and Co_Fa_Key = 0. If it is a contact at some facility, It Co_Fa_Key is some non-zero integer and Co_Cl_Key = 0. Client has a 1 to many relationship with Region. Region has a 1 to many relationship with Facility. All I want to do is create a local view for all contacts ordered by client name and facility name (if it is a contact for a specific facility)

TIA

Marcia