SORTING field in rapport problems

kmb@ah-bolte.dk

Hi

I have a few problem in a report;

I want to set filter on the field "Promised Delivery Date" in the table "salesline". I want the date to Ascending.

When I try to use the above field I get the message this field is not a active key field.

In this report I also schold use a field "Prod. Order No." from the tabel "Prod. Order Line". I have set DataItemLink to "Item No.=FIELD(No.)" and it inserts the prod.Order no. correctly, but it place the same number on the lines below in the report although it is not the right number.

Prod.no salesordre no customerordre
3000 100106 B99/4500679
3000 100711 125389-1



I hope somebody could help me.

Kristina
[/code]

ara3n

in order to sort on a field, you need to create a key for that field in the table.
as for the same prod. no., you need to CLEAR(PRODUCTIONLINE) the production no if you don't find it, otherwise it will still point to the previous record, which is what you are experiencing.