Sorting on a form with two tables

[Bubsi]

I have a form with data from 2 tables. The data of the main table I can sort by the indexes in the Record | Filter dialog box. But the data of the second table I can not sort in this way. There are also indexes on the second table.

Is there a possibility to sort the data from the second table in my form?


Thanks,
Bubsi

 

[footpad]

Bubsi,

You can use indexes to sort the second table; simply create a set of indexes that each contain the linking field as the first field. For example, suppose your key is ID and that you have fields called Desc, Date, and Amount.

To sort the detail table, you'd create three indexes:

-- SortDesc contains ID and Desc
-- SortDate contains ID and Date
-- SortAmt contains ID and Amount

If you want to provide descending sorts, you'd create a set of indexes that contain the same fields, but order things in the proper order.

As long as the first field in the index is the linking field, you can use the index to link.

Hope this helps...

-- Lance

 

[Bubsi]

Hi Lance,

thanks for your help.
But it won't work. Perhaps there is a problem with the linking of the two tables.
Is it possible to send you my example ?

Bubsi

 

[footpad]

Bubsi,

Feel free to send me an example at the email address shown in my username details or the one shown on many of the pages on my site.

I'll have a look at them and see what I can discover. I'll reply privately and also provide a summary replay to this thread.

Hoping to help...

-- Lance