> To create a relationship in the Data environment you click and drag a field >from one table to a field or index in the other table. This will create the
> relationship for you in the DE. These relations have no effect on the >relations in the database, they are the temporal relationships that exist for >that form
> or report only.
>
> JimB
> Microsoft MVP
> Visual FoxPro Trainer/Developer
> Co-author Visual FoxPro 3.0 Unleashed


I tried it - and met with marginal success. It seems that one minute it will allow me to drag a field from the Primary table to the corresponding index in the Relating table and the next minute, it won't.

Ultimately, playing around let me create all the links except one. And I don't understand it. There are three tables related in this link. I can link the left table with the center one (field to index), or I can link the right table with the center one (field to index) - but it won't let me do both at the same time. And yet, the same relationship exists between other tables in the same Data environment. Is Visual Foxpro 5.0 buggy in this sense? For some of the other links, I tried the exact same drag-and-drop procedure repeatedly; the first 10 times it wouldn't allow it (circle with slash through it), but on the following try, it did. No indication whatsoever as to what made the difference.

Any ideas?



Daniel