>>I have a Table A with a list of plants, each of which has a species name. The species name list is held in Table B. Table A has a numeric code relating to Table B. Table B is indexed on this numeric code to facilitate the relationship. All of this ... the most basic relationship between two tables.
>>
>>However, I want to list Table A sorted A-Z by species? Clearly, if I switch the Table B index to the species names sorted AZ, the relationship to A is lost. My work around for now is to include a (redundant)short species name field in Table A and to index on this. It works - but can't be the correct way.
>
>Denis,
>
>The relationship shouldn't be lost if you change the order of Table A... An dependent index on Table A is not mandatory to the relationship.
>
>Renoir

Denis,

Sorry. Not what you asked - you wanted it ordered by Species which is not in TableA. I like Jim's answer best.

Renoir