General information
Category:
Coding, syntax & commands
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
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only