Hola Ulises,

If you are trying to do things with more than 2 tables, I suggest you create your view through code (create sql view...) and then finish it using Erik Moore's eview program. Look for it in the files area.

VFP's view designer is, at best, very unreliable.

Alex


>I'm trying to establish a MtM relationship between 2 tables. One is a students table, each student has a unique Id#, and the other is a classes table. Each class has a unique Id# also. I'm using a 3rd table as a link between those two students-classes tables, but somehow I'm not getting the expected results. Cant' build a view with these 3 tables. I got error message saying one same table can't be the child for two parent tables. Any general guidelines on how to succesfuly accomplish this?
>Thanks in advance for your time.
>Ulises.