How do you remove the last row in a portal??

[J__]

Suppose you have a grid with some items in it, say customer names.

You have a button on the far right, which allows the user to jump to another layout to see more details about the customer record in the grid.

the thing is that there is always a blank record after the last one and it shows a button, but no data?

is there some magic setting to turn off this option?

thanks,

J__

[Fenton]

It shows the last row because you have "allow creation of related records" turned on for the TO relationship.

Question: Do you want to enter new records in the portal?

If not, then just turn off the option, in the relationship dialog.

If so, then you'll need to create a Container field, with global Storage, to put the button's graphic in. And a calculation, which checks some essential data before showing the button. Say you have an auto-entered serial ID field (which you usually should have).

_gButtDetails

_cgButtDetails = Case ( not IsEmpty (SerialID, _gButtDetails, "")

Put the calculation field in the portal, as a related field. Voila. No button on the last row.

There is what some would call a bug in 7.0v3 in that the global field must be 1 pixel bigger than the graphic on each side, or it gets chopped (with Crop option, which is the only reasonable one for this).

In earlier versions it could be exactly the same size, with borders on all sides, with line width set to none. Who knows what the future holds?

Duplicate the global field to get the calculation field. Saves some time.

[J__]

excellent. Thanks for the response, I really appreciate it.

But wait!

You make the container field a calculation field?

how does that hide the button? with a case? I'm expecting something like HideButton()?

thanks again for the answer.

sincerely,

J__

[RalphL]

Since the button is a container field and there is no record for the last row. There is no button until a record is created.

[J__]

ah, right I get it. yeh duh... I wasn't thinking of it that way.

thanks,

sincerely,

J__