ow to make a button's appearance conditional

[Steve Buchan]

Looking to display 'Next Record' Button, only when there is a next record to display in the set. Any ideas on how to make a button's appearance conditional without switching layouts?

[-Queue-]

Two ways:

1. Create a graphic for the button and paste it into a global container field. Then create an unstored calculated field equal to Case( not Get(RecordNumber) = Get(FoundCount), gContainerField ). Put this calculated field on the layout and format the graphic to display as desired. In the script attached to the button, first test that the field is empty.

2. Create an unstored field equal to not Get(RecordNumber) = Get(FoundCount). Then create a relationship from this field to a constant number calculation field equal to 1. Put a portal on your layout, using this relationship, with no border and displaying only one row. Then put your button into the portal and make sure it doesn't overlap its borders.

[MoonShadow]

Well, here is what I would do... Create two calculations (number):

Get ( RecordNumber ) < Get ( FoundCount ) set as unstored

1 this calculation could be called kOne (for Key 1)

Create a second table occurance of your main table. Join the first calculation to kOne using =

Place a portal on your layout based upon the second TO. Create your button and attach your script then drag it into the portal. Your Next Record button will only appear when you are viewing all but your last record - or your last record in a found set.