Luco

Since VFP added the integer field type, I strongly recommend that you stop using compound keys for relations. Just use uniquely internally generated keys in sequence to provide the links between tables. With parameterized views retrieving child records can be done in any order you choose.

>I'm used to work with compound keys. For me that means that the primary key of a table consists of two fields which make it unique.
>
>When I set relations, I can make a relation using only the half of the key(1 field) which I relate to another table.
>
>How can you implement this in Vfp ?