Cannot sort portals

[R2D2]

Hi !

I have again a new problem... I have created a portal (showing only 1 row) with correctly defined relations. But what ever I try there is always only the first related record. And I wanted the latest to be shown. I have tried to sort the related file and define the portal so that it would sort the related record with no results.

Is this a bug or do I again miss something ??

Arttu

[Lee Smith]

It isn't a BUG. Do you have a date, record ID Num, or something that you are using as the bases of your Sort? If so, sort the Relationship, in the "Edit Relationship" box using the that field, double check that the fields are of the same type (i.e. both are dates, or numbers, etc.) .

If it still not working, than tell us what fields you are using as the relationship, and what field you are sorting on.

You can always attach a sample of your file(s) too.

Lee

Edited December 23, 2005 by Guest

[R2D2]

Thanks, Lee !

I have a TimeStamp in every record and I have sorted the records in relation. But it still doesn't work. Here is an attachement.

The solution will be in an operation center to manage different unit's contact times. Every unit (CS) should report their position and status every 30 minutes (in this demo every 3 minutes). If the unit dosn't report in 2 minutes the time in call sign will turn orange. After 3 minutes it turns red. The "Action" field should show the latest status, but for some reason it shows only the first record. Now the relation is sorted wrong (in ascdending order), but it doesn,t work in descending order either.

There is 2 files: OPS_center and logfile. The first one is "Status table" and the logfile should log every action and contact.

This is a VERY preliminary file, so there is hardly any scripts or user interface.

It seems that I am doing something wrong... :

Thank you in advance and Merry Xmas to everybody !

Arttu

Edited December 24, 2005 by Guest

[R2D2]

Uh oh... I'm not sure if the attachement is in my last post. But here I try again...

Arttu

OPS.zip

[Lee Smith]

The field you are showing is called "Attnentiion", the calculation for this field is showing the same results for each record.

Lee

[R2D2]

Lee,

Thank you ! Now I got it !! And surprisingly it is working. Sometimes thinking too complicately isn't good in this business... :

Thanks again for your help !

Arttu