>Assume we have TableA TableB and TableC, the relations would be like this;
>
> TableA -------->> TableB -------->> TableC
>
> The relation you described in your message was;
>
> TableA -------->> TableB <<-------- TableC
>
> That one won't work.
>
> JimB
> Microsoft MVP
> Visual FoxPro Trainer/Developer
> Co-author Visual FoxPro 3.0 Unleashed


I think I understand what you are saying - but what's confusing me is that what you are telling me won't work is exactly what I have. Meaning that two such relationships already exist - I'm just having trouble with the third.

I have two other relationships set where Table A is linked to Table B (Field to index), and Table C is linked to Table B (field to index). If that's an invalid relationship, why did VFP allow it in the first place?



Daniel