Hello,

If I understood it correctly, the VFP database supports the use of a composite primary key only through function-based indexes. So if I take the following situation:

Table A, key A_id (character)
Table B, key B_id (auto-incremented integer)
Table C establishing a m-n relationship between A and B, key (A_id,B_id)
For C's primary key I have to create an index based on a function like A_id+TRIM(STR(B_id))

That is probably what I will often have to do as I will have to add tables using auto-increments to an existing database which is using only character primary keys. It will certainly work. But now, It looks to me as I will be losing all benefits of using the more compact integer keys over the longer character keys. Is there a cleverer way to define a composite key ?