>I have got this generated automatically by the VFP View Designer. The sequential order should have been maintained as I first saved the view with the first join and got it working on my form. Then reopened it and added the same table again in the View and joined this another one. I tried to switch the joins into 2 places in seq. order i think was valid but then the VFP view designer said that the index is corrupted and that I should rebuild it for this view???
You must be using VFP 5, 6 or 7. VFP 8 made some *very* useful tweaks to the View Designer to make it work better. Another option is eView, a freeware replacement for the View Designer. Other than that, you may need to maintain the view in code.
>Any suggestions? Any way you feel the view SQL should be I can cut-paste (I am not much of a coder) into the View using View Editor which will allow me to do it.
Just a guess, but try
SELECT TINQUIRY.*, MAGENT.CAGENTNAME, MAGENCT.CAGENTCITY, MPARTY.CPARTYNAME, MPARTY.CPARTYCITY ;
FROM VSO3!TINQUIRY ;
INNER JOIN VSO3!MACCOUNTS MAGENT ;
ON TINQUIRY.IAGENTID = MAGENT.IID ;
INNER JOIN VSO3!MACCOUNTS MACCOUNTS_A ;
ON TINQUIRY.IPARTYID = MPARTY.IID ;
ORDER BY TINQUIRY.DDT, TINQUIRY.CBK, TINQUIRY.INOI