Go to "page" # field, all records after that pg appear?

[Logan263]

In editing my db, I have realized I am missing an important feature.
The db is for entering info; there is a name for the info., a
category, page # and item # on that page. In editing, I'm finding it
would be really good to have a "Go to record" type feature but that
deals with the data in one of the fields: the page #.

Sure, currently I can do a find for the page # but that limits me to
bringing up only that page (or if more than one item on it, several
records corresponding to it). When I need to edit beyond that, I
must show all records which then takes me right back to the
problem of how to easily get to the next page to edit.

The reason the above is important is that we reach a certain point
when editing. When we stop and come back, one is further
ahead so it would be nice to start after page number "X", whatever we
left off at - and then continue editing from there till the end.

Trouble with using the "Go to record ..." function is that it's hard
to guess what record corresponds to what page.

Thanks and any help appreciated with being able to go to any page #
and then continuing editing from there.

[Howard Schlossberg]

Try this:
1) Add a global field called gPageNum and put it on your layout.

2) Create a relationship from that global field to the Page# field.

3) Add a button on your layout, right next to the gPageNum field; define
it to Go To Related Record using the new relationship you just created.

4) Now type a page number into the global and click the button. If you
defined the button with the 'show only related' option, then it will
only show exact matches; otherwise it will keep whatever found set you
had (assuming the desired page is within that found set and it is sorted
by page #) and it will go directly to the desired page #.

Logan263 wrote:

> In editing my db, I have realized I am missing an important feature.
> The db is for entering info; there is a name for the info., a
> category, page # and item # on that page. In editing, I'm finding it
> would be really good to have a "Go to record" type feature but that
> deals with the data in one of the fields: the page #.
>
> Sure, currently I can do a find for the page # but that limits me to
> bringing up only that page (or if more than one item on it, several
> records corresponding to it). When I need to edit beyond that, I
> must show all records which then takes me right back to the
> problem of how to easily get to the next page to edit.
>
> The reason the above is important is that we reach a certain point
> when editing. When we stop and come back, one is further
> ahead so it would be nice to start after page number "X", whatever we
> left off at - and then continue editing from there till the end.
>
> Trouble with using the "Go to record ..." function is that it's hard
> to guess what record corresponds to what page.
>
> Thanks and any help appreciated with being able to go to any page #
> and then continuing editing from there.

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California
Associate Member, FileMaker Solutions Alliance

[Logan263]

On Thu, 30 Oct 2003 08:28:42 -0800, Howard Schlossberg
<howard@antispahm.fmprosolutions.com> wrote:

>Try this:
>1) Add a global field called gPageNum and put it on your layout.
>
>2) Create a relationship from that global field to the Page# field.
>
>3) Add a button on your layout, right next to the gPageNum field; define
>it to Go To Related Record using the new relationship you just created.
>
>4) Now type a page number into the global and click the button. If you
>defined the button with the 'show only related' option, then it will
>only show exact matches; otherwise it will keep whatever found set you
>had (assuming the desired page is within that found set and it is sorted
>by page #) and it will go directly to the desired page #.

Oh, phew. It can be done! I'm very new on global fields so this will
be fun to learn.

Thank you! Much appreciated.

p.p.s, I am going to have to add a page in my db as a "credits" page.
It's getting very, very long. This group and some forums on the
internet and some yahoo groups will all get mention. This program is
becoming quite sophisticated and well-rounded but I certainly could
never have done all that I have without help. Tx!!

>Logan263 wrote:
>

>> In editing my db, I have realized I am missing an important feature.
>> The db is for entering info; there is a name for the info., a
>> category, page # and item # on that page. In editing, I'm finding it
>> would be really good to have a "Go to record" type feature but that
>> deals with the data in one of the fields: the page #.
>>
>> Sure, currently I can do a find for the page # but that limits me to
>> bringing up only that page (or if more than one item on it, several
>> records corresponding to it). When I need to edit beyond that, I
>> must show all records which then takes me right back to the
>> problem of how to easily get to the next page to edit.
>>
>> The reason the above is important is that we reach a certain point
>> when editing. When we stop and come back, one is further
>> ahead so it would be nice to start after page number "X", whatever we
>> left off at - and then continue editing from there till the end.
>>
>> Trouble with using the "Go to record ..." function is that it's hard
>> to guess what record corresponds to what page.
>>
>> Thanks and any help appreciated with being able to go to any page #
>> and then continuing editing from there.