Update container field

[margita]

I am using John Osborne's technique for not displaying an icon in the last portal row if there

is no record there (using a global container field and an auto-calculation container field).

This works fine. However, I am using it in a database which already has a number of records. The container fields work fine for newly entered records. But the previously entered records do not

display the icon on their portal rows.

Is there any way the container can be updated for previously entered records on the portal rows?

Many thanks,

Margita

[comment]

Use an unstored calculation field instead. Auto-entering the icon into a container replicates the icon needlessly across all records.

[margita]

Many thanks. I take it that if I change the Autoenter to unstored calculation the way I have it at the moment, it will show the icon in all the portal rows, including the last blank row? Would I have to construct something else?

Thanks again,

Margita

[comment]

I take it that if I change the Autoenter to unstored calculation the way I have it at the moment, it will show the icon in all the portal rows, including the last blank row?

To show the icon in all the portal rows, including the last, we don't need a calculation - we could just place the global container, or the icon itself, inside the portal. The purpose of the calculation is to prevent the icon showing in the last row. The calculation can be something like:

Case ( ChildID ; gContainerfield )

where ChildID is the auto-entered serial number in the child table. Set the result of the calculation to type Container.

[margita]

Many thanks - I was away, hence the late reply.