>I'm new to this so this is an elementary question. In setting up persistent relationships, I have 1 table with a primary key that is one field. That is the parent table. In the child table, does the index that's related to this parent have to be on that field only or can I have it on 2 fields with the first one being the one that matches the parent table? For example - the parent table has a primary key on code; the child table has an index on code & subcode. Do I need to add an index to the child table that is code only?
>
>Thanks.

This is very similar to setting a normal relation between tables. The only way the relation will work is if the value of the index record in the parent is equal to the value in the child table. If you can do that with an index on multiple fields, then you can set the relation. Whatever value you have in the parent has to be of the same data type, width and value in the child table to get a match.