> Are there any problems using the VFP View Designer
> when views are created using "sequential join"
> syntax?
The problem is the view designer. As bad as it sounds, VFP's view designer sucks. I believe Eric Moore and/or Steve Sawyer have some alternatives to the view designer that you can use to work with complex joins. Check on the downloads sections.
In addition, you can generate a PRG with the code of the view (by using GenDBC.PRG that comes with VFP.) This will create a PRG with the code for the view. You can modify this PRG, run it again and it will recreate the view.
> Is the problem because I'm using free tables?
No, it isn't.
Hector Correa