composite secondary index; help needed

Dear All,

I need to create a secondary index with some fields ascending and some

I tried to do it with "Define Index" in Database Desktop - but it
allows me to have either ALL fields ascending or ALL fields

AddIndex has only one option for the totality of fields.

I can do it easily in Access tables, but I am fighting in vain
with Delphi. What I  am doing wrong?

Thank you in advance,

Arkadiusz Jadczyk