>Hello,
>
>I use VFP50. When we are making persistent relat. during database desing, we only can do it between indexes (Normally one-to-many).
>
>But many times (if i am not doing something wrong) we have to 'invert' these relations in the form's DE making many-to-one relations. This is the case when a 'detail table' must 'see' parent records in more than one 'master table'.
>
>Why VFP doesn't allow me to make relations between indexes in the form's DE; only between one (1) field and other indexes. Here is the problem: If i use compound keys, i have to re-write the relational expresions.
>
>Is this solved in VFP60 ?
>Am i doing something wrong ? or
>Does anybody know why not?
>
>Thanks
>
>Juan Carlos Jaramillo
If detail records need to "see" information from multiple parent tables, you should look into using views, if you're not doing so already.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up